View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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" wrote in message
...
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?