Text within Text

[Ampleford]

I'm writing some text which is conditional on a set of values. This text is then shown in the form of a message box to the user. I'd like to be able to add quotes within the text, but the system doesn't like it.

eg

=if(A1=1,"That's good","That's bad, please click on "OK" and continue")

in that I'd like the OK in quote marks.....


how do I do that ?

 

[NBVC]

Put this instead....

=if(A1=1,"That's good","That's bad, please click on ""OK"" and continue")

 

[Richard Schollar]

Within your formula in Excel you would write it as:

=if(A1=1,"That's good","That's bad, please click on " & CHAR(34) & "OK" & CHAR(34) & " and continue")

Best regards

Richard