| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
