View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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