Adding Quote Marks To A Very Long Column. How, Please ?
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 |
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 |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com