Adding Quote Marks To A Very Long Column. How, Please ?
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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|