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" <a_dallas_boy@discussions.microsoft.com> wrote in message
news:D01E4B1D-F61B-4B14-A184-BFAB029A0E11@microsoft.com...
> 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)>Values>OK>Esc.

Delete column A.


Gord Dibben Excel MVP

On Thu, 17 Feb 2005 14:33:01 -0800, a_dallas_boy
<a_dallas_boy@discussions.microsoft.com> wrote:

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