Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add quote marks around cell contents? | Excel Discussion (Misc queries) | |||
How do I force quote marks when exporting to a csv? | Excel Discussion (Misc queries) | |||
Quote Marks Through VBA | Excel Discussion (Misc queries) | |||
How to keep quote marks for CSV in excel | Excel Discussion (Misc queries) | |||
How do you look for quote marks? | Excel Programming |