View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default How to enclose text in a cell in quotes

You could, of course, use a helper column to get your results. For example,
if your data begins in cell A1, then use this formula in another column and
copy down as needed.

="""" & A1 & """"

HTH,
Paul

--

"booker@mgt" wrote in message
...
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