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. ??