Quotation Marks as Text
 

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

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

Quotation Marks as Text
 

Hi Kelly

Look at this example:

=IF(A1=1,"""True""","""False""")

Hopes it helps.

Regards,
Per
"Kelly C" <Kelly skrev i meddelelsen
...
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