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

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"tywlam" wrote:

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