Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"" (double quotes with nothing between) | Excel Discussion (Misc queries) | |||
"" (double quotes with nothing between) | Excel Discussion (Misc queries) | |||
Inserting "quotes" around characaters in a cell | Excel Discussion (Misc queries) | |||
how to copy contents of a cell and remove any quotes " " | Excel Discussion (Misc queries) | |||
"formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) |