Phone Number Formats

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?
 
D

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top