Insert a column to left (assume stuff is in A)
In B1 ="("&A1&")"
Copy down column
Select all of B; Copy followed by Edit|Paste Special->Values
Now you can delete column A
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Terri" <Terri@discussions.microsoft.com> wrote in message
news:462238B2-4AF6-4FD0-A91F-AB75CA3F359B@microsoft.com...
>I have a column in Excel that I want to enclose the contents with brackets
>in
> every cell. Is there an easy way to do that?
Bookmarks