Phone Number Formats

[dpgfb]

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]

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.)

 

[Eduardo]

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