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