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.

Try

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

note the final "&"

Clif

"Paul Schrum" <(E-Mail Removed)> wrote in message
news:be55bcc1-02ea-4d57-b125-(E-Mail Removed)...
>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

(clare reads his mail with moe, nomail feeds the bit bucket :-)

Clif,

Your suggestion works. Thanks a bunch.

- Paul

On Dec 21, 3:20*pm, "Clif McIrvin" <clare.nom...@gmail.com> wrote:
> Try
>
> ="""xy="&TEXT(O13,"0.0000")&","&TEXT(P13,"0.0000")&""""
>
> note the final "&"
>
> Clif
>
> "Paul Schrum" <paul.sch...@gmail.com> wrote in message
>
> news:be55bcc1-02ea-4d57-b125-(E-Mail Removed)...
>
>
>
>
>
> >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
>
> (clare reads his mail with moe, nomail feeds the bit bucket :-)- Hide quoted text -
>
> - Show quoted text -

"Paul Schrum" <(E-Mail Removed)> wrote in message
news:ae6faa5f-1259-4958-98ba-(E-Mail Removed)...
Clif,

Your suggestion works. Thanks a bunch.


------

Thanks for the feedback

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

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>.)


On 12/21/2010 13:57, Paul Schrum wrote:
> 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.

--
Dave Peterson