How do you remove phone format????

T

TotallyConfused

I have a list of phone number with phone format (###) ###-####. I need to
remove the phone format and replace existing numbers as text "##########"
How do I do this please???? Thank you.
 
S

Sheeloo

Select the cells
Right-click and choose Format Cells
In the Number tab, choose TEXT and click OK
 
D

Dave Peterson

I would use a few edit|replaces.

Change ( to nothing.
change ) to nothing.
change - to nothing.
change (spacebar) to nothing.

And any other characters that you find in your strings.

Then I'd either use a custom format:
0000000000
or if I really wanted text, I'd use a helper cell and a formula like:
=text(a1,rept("0",10)
 

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