You could insert a helper column to the right and use a formula like:

=char(34) & a1 & char(34)
or
=""""&A1&""""
Drag down as far as you need.

Then copy this column and paste special|values over the original column.

Then delete the helper column.


booker@mgt wrote:

If I have some text in a cell and I want to wrap that text in quotes, do you
know of a simple way to do that

i.e Cell says Whoever answers this question is the greatest

and I want it to be €œWhoever answers this question is the greatest€�

And I want to do that for everything in that particular column?

Thanks

--

Dave Peterson