Highlight the column, EditReplace

find: -
Replace with: (leave this blank)

Replace All

Format column as phone #

"WarrenL" wrote:

I have a long list of phone numbers that were input as text in the following
format: xxx-xxx-xxxx. If I change the cell format to "cutom" and "phone",
under edit cells, then remove the hyphens, I end up with (xxx) xxx-xxxx. This
is what I want; however cannot figure out hot to write a macro or otherwise
to do it automatically.