View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default questions re quotes and csv

If text is in F19, then:

="""" & F19 & """" will give you the text with double quotes before and
after.
--
Gary''s Student


"Sgt.DA" wrote:


is there a way to put all my cells in quotes without manually editting
each one?

thanks in advanced
DA


--
Sgt.DA
------------------------------------------------------------------------
Sgt.DA's Profile: http://www.excelforum.com/member.php...o&userid=27281
View this thread: http://www.excelforum.com/showthread...hreadid=524473