Format cell range in a Parenthesis

Question

How to custom format a cell range with a parenthesis around text.

for example I need to format this column which contain Name of people inside a parenthesis, so how do I do that, anyone help me please? here is a screen shot

Name
Hon
For
Che
Hon
Toy
Toy
Hon
For
Che
Che
GMC
GMC
For
Hon
Toy
GMC
Che
Hon
Toy
For

Moved from Internet Explorer

Answer 1

Custom Format   

"("General")";"("General")";"("General")";"("@")"

I think you can reduce that Custom Format down to this...

(General);(@)

Answer 2

Custom Format   

"("General")";"("General")";"("General")";"("@")"

Or Macro

Sub Test()

Dim cell As Range

For Each cell In Selection

cell.Value = "(" & cell.Value & ")"

Next cell

End Sub

Note: the macro does not format. . . . .it hard codes the parens.

Gord

Answer 3

Your construct works as advertised Rick

Thanks for the update.

Gord