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