Excel - adding parenthesis 2

[Acowaz]

I need help in adding parenthesis in a column. I need to keep the text in column A but add the parenthesis around the current text. Any help is appreciated.

 

[Bowers74]

Enter the following formula into cell B1:

="("&A1&&quot"

Now copy down!

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[combo]

If you only need to see parenthesis but have text unchanged - format text as custom (any number will be converted to text) with:
(@)

combo

 

[Acowaz]

Thanks Bowers74. It works great.

 

[Bowers74]

Thanks for the star Acowaz!

combo's suggestion is good too.

You might want to try it to see which one works better for you!

combo:

Here is a star from me, because I didn't know about that Custom Format technique and I'm sure that I will need to use it in the future!





Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[combo]

Thanks Mike, there is a good description of custom formats at KB:

http://support.microsoft.com/default.aspx?scid=/support/Excel/Content/Formats/default.asp#intro

combo