| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove -, keep 0 in phonenumber
I need to format phonenumbers of the type 045-69825 to 04569825.
When I try the search and replace for the -, I lose the 0 in the beginning of the number. I treid formating the cells to text first, but the 0 still goes away. Help, anyone? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove -, keep 0 in phonenumber
Hi Sofie
One way =TEXT(SUBSTITUTE(A1,"-",""),"00000000") -- Regards Roger Govier "sofie" wrote in message ... I need to format phonenumbers of the type 045-69825 to 04569825. When I try the search and replace for the -, I lose the 0 in the beginning of the number. I treid formating the cells to text first, but the 0 still goes away. Help, anyone? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove -, keep 0 in phonenumber
Thanx, I'll try that!
"Roger Govier" skrev: Hi Sofie One way =TEXT(SUBSTITUTE(A1,"-",""),"00000000") -- Regards Roger Govier "sofie" wrote in message ... I need to format phonenumbers of the type 045-69825 to 04569825. When I try the search and replace for the -, I lose the 0 in the beginning of the number. I treid formating the cells to text first, but the 0 still goes away. Help, anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to prevent Remove Split or Unfreeze Panes? | Excel Discussion (Misc queries) | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Linear Mode
