View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.