Is there a quick way to remove the dashes and parentheses from phone numbers?

		Microsoft Office Forums > Microsoft Excel > Excel
Is there a quick way to remove the dashes and parentheses from phone numbers?

FAQ

Thread Tools

Display Modes

09-11-2014, 10:21 AM

Stacy

Windows 7 64bit Is there a quick way to remove the dashes and parentheses from phone numbers?

Office 2013

Novice

Join Date: Sep 2014

Location: Greeley, CO

Posts: 4

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!

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 AM.