Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Can 2 different hyperlinks be in the same Excel cell? | Excel Worksheet Functions |