Is There A Way to Auto Add Single Quotes Around Text? 1

[txdave35]

Hey guys,

I have an Excel spreadsheet with a column of text data. I want the text data in each cell to be surrounded by a pair of single quotes.

Is there any way to get Excel to automatically do this so I don't have to manually type in the quotes in each cell? I am running Excel 2003, and I really don't know much about VB scripting or complex formulas. Thanks!

 

[SkipVought]

Hi,
[tt]
=""""&A2&""""
[/tt]
and copy down.



Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[txdave35]

Thanks Skip. However, this code places double quotes around my text. Is there a way to get it to place single quotes? Thanks!

 

[SkipVought]

We have QUOTES and APOSTROPHIES
[tt]
="'"&A2&"'"
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[buitenhek]

You're the man skip. I have learned a lot from your posts.
Thanks

 

[SkipVought]

Thanx!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}