software

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: www.excelforum.com/member.php...oamp;userid=27281
View this thread: www.excelforum.com/showthread...hreadid=524473If text is in F19, then:

=quot;quot;quot;quot; amp; F19 amp; quot;quot;quot;quot; will give you the text with double quotes before and
after.
--
Gary''s Studentquot;Sgt.DAquot; wrote:

gt;
gt; is there a way to put all my cells in quotes without manually editting
gt; each one?
gt;
gt; thanks in advanced
gt; DA
gt;
gt;
gt; --
gt; Sgt.DA
gt; ------------------------------------------------------------------------
gt; Sgt.DA's Profile: www.excelforum.com/member.php...oamp;userid=27281
gt; View this thread: www.excelforum.com/showthread...hreadid=524473
gt;
gt;

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) amp; r.Value amp; Chr(34)
Next
End Sub

Then select an area in the worksheet and run the macro.
--
Gary's Studentquot;Sgt.DAquot; wrote:

gt;
gt; is there a way to put all my cells in quotes without manually editting
gt; each one?
gt;
gt; thanks in advanced
gt; DA
gt;
gt;
gt; --
gt; Sgt.DA
gt; ------------------------------------------------------------------------
gt; Sgt.DA's Profile: www.excelforum.com/member.php...oamp;userid=27281
gt; View this thread: www.excelforum.com/showthread...hreadid=524473
gt;
gt;