MrExcel Publishing
Your One Stop for Excel Tips & Solutions

putting quotes around a string


Posted by Xay on November 08, 2001 9:32 AM

I have an Excel file about 400 lines long containing a string only in column A without any spaces between the characters in the string. I would like a way to put a single parenthesis at the beginning and the end of the string. Is there a way this can be done?

Here is an example of one cell containing the string I would like to put the parenthesis around:

221/T1/CMBRMAORDS4/CMBRMAORDS3

Basically I want to somehow automatically put parenthesis around it so it looks like this for each cell:

'221/T1/CMBRMAORDS4/CMBRMAORDS3'

Please help. Thanks.


Posted by Aladin Akyurek on November 08, 2001 9:36 AM

Use: ="'"&A1&"'" (NT)

Posted by Xay on November 08, 2001 9:45 AM

Wow that was quick! Thank You.