View Single Post
  #1   Report Post  
vms
 
Posts: n/a
Default change format for phone numbers automatically

I have a worksheet with phone numbers in a column. Some are set up (xxx)
xxx-xxxx some are xxx-xxx-xxxx they all need to be xxxxxxxxxx
Is there a way to do this without retyping all the wrong ones or deleting
each space or -?
--
"You can have everything in life you want, if you will just help enough
other people get what they want." -- Zig Ziglar