Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add quote marks around cell contents?
I have a number of cells, that I need to place quote marks around. e.g. I
need 10-22 to read as "10-22" Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add quote marks around cell contents?
If the cells are contiguous, say in range A2:A10, then create a helper column
(say B) with the formula =""""&A2&"""" in B2 and copy down to B10 (that's FOUR double quotes front and back). Now select B2:B10, copy, select A2, Paste Special, Values. Delete the helper column. Similarly, for cells in a row, create a helper row with formulas as above and copy/paste special. -- TedMi "Shotsy" wrote: I have a number of cells, that I need to place quote marks around. e.g. I need 10-22 to read as "10-22" Any help would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add quote marks around cell contents?
If you have 10-22 in A1, then you could use this:
=CHAR(34)&A1&CHAR(34) then copy down as required. You could fix the values then copy back over the original data if required. Hope this helps. Pete "Shotsy" wrote in message ... I have a number of cells, that I need to place quote marks around. e.g. I need 10-22 to read as "10-22" Any help would be appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add quote marks around cell contents?
Thank you Thank you.
I appreciate the quick responses. Have a Great Day! Shotsy... "Shotsy" wrote: I have a number of cells, that I need to place quote marks around. e.g. I need 10-22 to read as "10-22" Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I force quote marks when exporting to a csv? | Excel Discussion (Misc queries) | |||
How do I find & replace quote marks with the word inch? | Excel Discussion (Misc queries) | |||
Quote Marks Through VBA | Excel Discussion (Misc queries) | |||
Quote marks in Formulas passed from VB Script in Excel | Excel Worksheet Functions | |||
How to keep quote marks for CSV in excel | Excel Discussion (Misc queries) |