View Single Post
  #4   Report Post  
James
 
Posts: n/a
Default

You could enter the following fomula in the column next to it

="(" & A1 &")"

Alternatively you could select the cells and run the macro below

Sub Test()
Dim cell As Range
For Each cell In Selection
cell.Value = "(" & cell.Value & ")"
Next cell

End Sub

James

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