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.

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

"TotallyConfused" wrote:

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.

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)


TotallyConfused wrote:

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.

--

Dave Peterson