Hi LMR,

Provided all of your data is exactly as posted and assuming
it is in column A put this in B1 and drag down to the end
of your data.
="("&LEFT(A1,3)&") "&MID(A1,5,8)

Alternatively if there are no blanks in column A just highlight
B1 and double click the fill handle, instead of dragging down.

HTH
Martin


"LMR" wrote in message
...
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