How to Strip Formatting out of Phone Numbers

LoanTek’s CRM requires that phone numbers be entered without special formatting. Here is an example of a phone number that would not import properly: Ex. (444) 555-6666. To remove this formatting, follow the steps below:

  1. Insert a blank column to the right of the column containing the phone number you wish to reformat.
     

  2. Copy and paste the following code into the cell in the top of the new column directly to the right of the phone number you wish to change. If your column header is not G3, replace the column header with the name the header that contains your numbers.
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G3,"(",""),")",""),"-","")," ",""),".","")

     

  3. Press Enter. This should correct the cell to the immediate left of the formula.
     

  4. Double click the bottom right corner of the box with the corrected phone format to fill the formula all the way down the page.
     

  5. Create another blank column next to your new phone numbers. Copy the new formatted phone numbers and paste them over the old formatted numbers. You should right click the number closest to the top of the column and paste values.

     

This article is provided for informational purposes only and is subject to change without notice. It's not intended to include every feature or service that LoanTek provides.

Add Feedback