I have two columns of numbers. I'd like to get rid of the old formatted
numbers after the transformation.

Thanks for your fast response!!!!

"Gemini" wrote:

LMR, which version of Excel are you using? Also, are these phone numbers in
one single column? Once the transformation is achieved, do you plan to keep
the old numbers or get rid of them?

-- Gemini

"LMR" wrote:

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