|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Is there a quick way to remove the dashes and parentheses from phone numbers?
I have thousands of contacts with phone, fax, and mobile numbers and I need to change the format for import compatibility with new software.
Current format: xxx-xxx-xxxx and (xxx)xxx-xxxx Software requires: xxxxxxxxxx If anyone has any ideas, please let me know. It will take me days to change each cell individually. Thank you! |
#2
|
|||
|
|||
Find and replace.
|
#3
|
||||
|
||||
I tried that and to no avail.
I finally figured out an equation using the substition function and it worked like a charm. Thank you! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Formatting Phone numbers | Marie_Melody | Mail Merge | 4 | 07-02-2014 04:22 PM |
can you change department field in phone numbers | pspec | Outlook | 2 | 04-05-2014 02:51 AM |
Need an excel formula to remove dashes in a number sequence | jyfuller | Excel Programming | 3 | 02-27-2013 10:32 PM |
Converting Phone Numbers Question | certified_techy | Excel | 8 | 06-08-2012 02:27 AM |
Create Custom Labels for Phone numbers | Tonistep | Outlook | 0 | 03-26-2012 02:57 PM |