Thread
:
Quotation Marks as Text
View Single Post
#
2
Posted to microsoft.public.excel.misc
RagDyeR
external usenet poster
Posts: 3,572
Quotation Marks as Text
Something like this:
=IF(N10,"""OK""","""NG""")
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kelly C" <Kelly
wrote in message
...
Quotation marks as text
I am using Excels IF Function to generate text that will be used in
another
application. The text will be savedd to Tab delimited file and then
imported
into the new application. That new application requires text strings be
enclosed in quotation marks. The problem is I cant get Excels IF
formula
to accept Quotation marks within Quotation marks or stated another way I
cant get Quotation Marks as part of my text string. Is there a way to
get
around this?
Thanks
Kelly
Reply With Quote
RagDyeR
View Public Profile
Find all posts by RagDyeR