How do you remove phone format????
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. |
How do you remove phone format????
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. |
How do you remove phone format????
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 |
All times are GMT +1. The time now is 12:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com