Thread: Formatting phone numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LMR LMR is offline
external usenet poster
  
Posts: 2
Default Formatting phone numbers
I am trying to format 2,000+ phone numbers from this format: 555-555-5555 h
to (555) 555-5555. Can anyone help with a formula to include the parenthesis
and remove the letter "h" at the end?

Thanks,
LMR
Reply With QuoteReply With Quote