Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-11-2014, 10:21 AM
Stacy's Avatar
Stacy Stacy is offline Is there a quick way to remove the dashes and parentheses from phone numbers? Windows 7 64bit Is there a quick way to remove the dashes and parentheses from phone numbers? Office 2013
Novice
Is there a quick way to remove the dashes and parentheses from phone numbers?
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a quick way to remove the dashes and parentheses from phone numbers? Mail Merge Formatting Phone numbers Marie_Melody Mail Merge 4 07-02-2014 04:22 PM
Is there a quick way to remove the dashes and parentheses from phone numbers? can you change department field in phone numbers pspec Outlook 2 04-05-2014 02:51 AM
Is there a quick way to remove the dashes and parentheses from phone numbers? 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 06:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft