LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2005, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 12 Aug 2005 08:12:47 -0700
Reply-To:   "data _null_;" <datanull@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "data _null_;" <datanull@GMAIL.COM>
Organization:   http://groups.google.com
Subject:   DDE EXCEL formula.replace: How to specify '0A'x decimal 0010
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset="iso-8859-1"

I can get formula.replace to work via DDE as long as I use text that is typeable. Of course I need to change '0A'x AKA "ALT-ENTER" to blank via DDE. I got the idea for this from reading related SAS-L post but I do not know how to get tell EXCEL what I want.

I tried ...

put '[formula.replace(&char(0010)," ",2,2)]'; /*does not work*/ put '[formula.replace("CNO","NEWCNO",2,2)]';

Please advise.

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu