How do I bracket text in cells by formatting a whole column?

[tywlam]

I want to bracket text or number in a cell, eg. abc becomes (abc). Or add
predetermined prefix to a number or text. How can I use the Text function
or other Excel functions to get these kinds of formats?

Thanks

 

[Sheeloo]

With abc in A1
use this in B1
="(" & A1 & ")"
or
=Concatenate("(",A1,")")

 

[Pecoflyer]

Another possibility:
select the cell - Right-click / Select Format cells - select Number
-Select Custom - In the format field enter "("####")"

Ok

With abc in A1
use this in B1
="(" & A1 & ")"
or
=Concatenate("(",A1,")")

--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster

 

[Sheeloo]

"I want to bracket text or number in a cell"

Formatting will work only with numbers...