Forum Discussion
Convert txt to numbers in excel then change format
Hi Everyone, I have phone numbers in excel that are txt and want to change to numbers. Also need to change format from (000) 000-0000 to 000-000-000. I have several worksheets with these two fo...
Hello bobby24,
The formula above is not appropriate for what you are looking to accomplish. My suggestion would be to use the "Text to Columns" feature. To do this:
- Select the cell with phone numbers that you would like to extract
- In the Data tab, select "Text to Columns"
- Select Delimited > Next, Comma > Next, General > Finish.
- Select all of the numbers and format as Special > Phone Number
For future reference, please ask new questions in a new thread.
I did not see this thread. Thank you Riny_van_Eekelen