How to do double quotes in "cell language"?

[Paul Schrum]

I have cells of "built up" text strings like this:

="xy="&TEXT(O12,"0.0000")&","&TEXT(P12,"0.0000")

which, when displayed, look like this:
xy=2524950.0000,341717.0000

The problem is, I want the cells to look like this:
CadInputQueue.SendKeyin "xy=2524950.0000,341717.0000"

but Excel interprets the double-quotes as deliminters in the cell
formula. I know how to get around this in a programming language
(using escape sequences), but I can't figure it out in "cell"
language. Do you know how to do it?

Note: The format I am seeking is for copying then pasting into a
Microstation VBA module.

 

[Clif McIrvin]

Try

="""xy="&TEXT(O13,"0.0000")&","&TEXT(P13,"0.0000")&""""

note the final "&"

Clif

 

[Paul Schrum]

Clif,

Your suggestion works. Thanks a bunch.

- Paul

 

[Clif McIrvin]

Clif,

Your suggestion works. Thanks a bunch.

 

[Dave Peterson]

Sometimes, I'll use =char(34) for the double quote:

=char(34)& "xy="&TEXT(O12,"0.0000")&","&TEXT(P12,"0.0000") & char(34)

(It hurts my brain less <vbg>.)