How do you add a parentesis to a column of email address?

[Guest]

I need to add a parenthesis in front of and behind a column of email
address's. ??

 

[Peo Sjoblom]

You can use a help column and a formula like

="("&A2&")"

copy down and then copy and paste special as values,
finally you can paste it over the old values if needed

in the above example A2 would hold the first value you want to change

 

[Gord Dibben]

Assuming column A has addresses.

In B1 enter ="(" & A1 & ")"

Double-click on the B1 fill handle to copy down.

When happy, Copy column B and Paste Special(in place)>Values>OK>Esc.

Delete column A.


Gord Dibben Excel MVP