I am trying to take a rules base excel document that has a number or
string: '0123456789
I need only the 10 numbers not the single quote '
I know i want the trim or the String right But what is the syntax and
where do i have to put it?
in the actions i have
Enter D("Acct Num") '0123456789
all i want is 0123456789
Thank you.
Clayton Leach
Integration Analyst
Phone 937-328-8104
FAX 937-328-6222
Information Systems
Community Mercy Health Partners
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.