Adding Quote Marks To A Very Long Column. How, Please ?

B

Bob

Hello,

Really going batty with this.

Using Excel 2007 and W7.

Have a column that I entered Text into.
Very long; way too long to change each cell individually.
The file is saved as a CSV.

Wish to put a quote mark at the beginning And end of the text.

Have searched in Google, and tried some suggestions that came up like:

use a Custom Format
"''"@"''"

and,
\"@\"

and several others.

None work.

Does anyone, please have a relatively simple way of doing it ?
One that you know definitely should work.

No macros please, as I'm really not too sharp with stuff.
Just something a relative beginner can use.

Much thanks,
Bob
 
C

Claus Busch

Hi Bob,

Am Wed, 13 Nov 2013 15:22:04 -0500 schrieb Bob:
and,
\"@\"

to change the format the above suggestion works for me
Format cells => Custom \"@\"
No macros please, as I'm really not too sharp with stuff.
Just something a relative beginner can use.

If your text is in column A and you don't want macros try:
=""""&A1&""""
Then copy the helper column and paste it back as values


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top