LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default How to do double quotes in "cell language"?

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.

Also posted in microsoft.public.excel.misc, but there does not seem to
be much action over there.

- Paul Schrum
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"" (double quotes with nothing between) Bob Umlas, Excel MVP Excel Discussion (Misc queries) 0 July 21st 08 10:59 PM
"" (double quotes with nothing between) Bob Phillips[_3_] Excel Discussion (Misc queries) 0 July 21st 08 10:36 PM
Inserting "quotes" around characaters in a cell Lolo79 Excel Discussion (Misc queries) 2 November 1st 07 11:52 PM
how to copy contents of a cell and remove any quotes " " jonny Excel Discussion (Misc queries) 2 January 28th 07 06:48 PM
"formula is too long" AND test for whether double-quotes are next-to text or number?? The Moose Excel Discussion (Misc queries) 2 September 14th 06 05:29 AM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"