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?

09-12-2014, 07:03 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

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!

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 11:06 PM.