Find solution
What's the easiest way to scrape residential phone numbers and names into .csv format?

In excel how do I convert a list of phone numbers in (000) 000-0000 format to 0000000000?

  • I have a list of 5000 phone numbers in (000) 000-0000 format that my boss would like me to change to 0000000000 format. I am not very familiar with excel. Is there a way I can do this all at once without having to go through each of the phone numbers to change them? Thanks A TON! I tried doing them one at a time and it will take me approximately 5 hours to complete that way. Thanks again

  • Answer:

    You must first format your whole column as text, otherwise you will get strange results. Right-click on the column header, Format cells, text, OK. Now click on the first cell, and do a find & replace (Ctrl-H) three times. First time, in the "Find what" box, type a single left bracket ( Click "Replace all". OK. Second time, in the "Find what" box, type a single right bracket followed by a space. Click "Replace all". OK. Third time, in the "Find what" box, type a single dash - Click "Replace all". OK.

Abe Duquette at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You can use a user defined function strips out all the brackets and space. Function extract_digits(cellvalue) Dim strExtract_digits strExtract_digits = "" For n = 1 To Len(cellvalue) If InStr(1, "0123456789", Mid(cellvalue, n, 1)) > 0 Then strExtract_digits = strExtract_digits & Mid(cellvalue, n, 1) End If Next extract_digits = Val(strExtract_digits) End Function Alternatively, you can use Excel search and replace function to replace brackets and spaces leaving only numbers. Takes less than 5 minutes.

puaka

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.