How can I add quote marks around cell contents?

S

Shotsy

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.
 
T

tedmi

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.
 
P

Pete_UK

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
 
S

Shotsy

Thank you Thank you.

I appreciate the quick responses.

Have a Great Day!

Shotsy...
 
Top