View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default How to do double quotes in "cell language"?

On Dec 21, 12:11*pm, 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"


In Excel, we would write:

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

That is, a double-quote as character in a string is represented by a
pair of double-quotes in a formula.

Does that help you at all?