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

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

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

--

Regards,

Peo Sjoblom

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

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)ValuesOKEsc.

Delete column A.


Gord Dibben Excel MVP

On Thu, 17 Feb 2005 14:33:01 -0800, a_dallas_boy
wrote:

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