Adding parenthesis to text data

[lesliepear]

I have a spread sheet with a column of e-mail addresses: [email protected]

I need to change the data (either in the same column or a new one) to be
([email protected]), - parentheses on either side and a comma at the end.

What is the fastest way to do this for 1500+ rows?

[shg]

Welcome to the forum.

in a convenient column, ="(" & a1 & ")," and copy down.

[lesliepear]

Welcome to the forum.

in a convenient column, ="(" & a1 " ")," and copy down.

That isn't working. When I enter:

="(" & m2 " "),"

I get an error in excel

[ncmay]

The other ampersand was ommitted.
The formula should read:

Please Login or Register  to view this content.