Phone Number Formats

  • Thread starter Thread starter dpgfb
  • Start date Start date
D

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?
 
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.)
 
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
 
Back
Top