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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.