is there a way to put all my cells in quotes without manually editting each one?
thanks in advanced
DA
is there a way to put all my cells in quotes without manually editting each one?
thanks in advanced
DA
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
>
>
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.
--
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks