Thread: Formatting Phone numbers
View Single Post
  #2  
Old 03-22-2007, 11:31 AM
oldchippy's Avatar
oldchippy oldchippy is offline
"Eagle Eyed" Forum Moderator
  
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,087
oldchippy is a jewel in the rough
Try something like this in B1,

="1"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","") then drag down column B
__________________
oldchippy
-------------


Click here >>> Top Excel links for beginners to Experts

Forum Rules >>>Please don't forget to read these
Reply With Quote