Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-11-2014, 10:21 AM
Stacy's Avatar
Stacy Stacy is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2014
Location: Greeley, CO
Posts: 4
Stacy is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 09-11-2014, 04:06 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Find and replace.
Reply With Quote
  #3  
Old 09-12-2014, 07:03 AM
Stacy's Avatar
Stacy Stacy is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2014
Location: Greeley, CO
Posts: 4
Stacy is on a distinguished road
Default

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!
Reply With Quote
Reply

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


All times are GMT -7. The time now is 01:56 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft