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

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

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

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

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

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

Ok

Sheeloo;308336 Wrote:
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


--
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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86195

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

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

Formatting will work only with numbers...

"Pecoflyer" wrote:


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

Ok

Sheeloo;308336 Wrote:
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


--
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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86195