questions re quotes and csv

S

Sgt.DA

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

thanks in advanced
DA
 
G

Gary''s Student

If text is in F19, then:

="""" & F19 & """" will give you the text with double quotes before and
after.
 
G

Gary''s Student

If you don't mind visual basic then enter the following macro:

Sub dont_quote_me()
Dim r As Range
For Each r In Selection
r.Value = Chr(34) & r.Value & Chr(34)
Next
End Sub

Then select an area in the worksheet and run the macro.
 
Top