Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Phone Number Formats
I have a column of phone numbers which are in the format 111 222 3333 and
need to reformat them with no spaces 1112223333. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Phone Number Formats
Select one of the cells.
Look at the formulabar. If you see the spaces, then select that column and use: Edit|replace what: (space character) with: (leave blank) replace all And give that column the number format you like. If you don't see the spaces, then try reformatting the range. Select the column Format|Cells|number tab|Custom type: 0000000000 (or whatever you like.) dpgfb wrote: I have a column of phone numbers which are in the format 111 222 3333 and need to reformat them with no spaces 1112223333. Any ideas? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Phone Number Formats
Hi,
Highlight the column, press CTRL H, Find what enter and space, don't enter anything in replace with, hit replace all if this helps please click yes, thanks "dpgfb" wrote: I have a column of phone numbers which are in the format 111 222 3333 and need to reformat them with no spaces 1112223333. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone number not | Excel Discussion (Misc queries) | |||
change ten digits in a cell to include phone # formats | Excel Discussion (Misc queries) | |||
Phone number | Excel Discussion (Misc queries) | |||
Phone Number Formats | Excel Discussion (Misc queries) | |||
Phone number formats | Excel Discussion (Misc queries) |