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...
PReagan Hey, I used your formula and it works perfectly! However, it only extracts 2 numbers. The third number is all zeros.
Example: "I'm trying to extract all of these numbers 02060874,02270190,02345347 in this sentence."
What I get in return is 2060874022701900000000.
How do I get that third number to appear instead of the zeros using this formula?
Thanks in advance!
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
