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