Windows 7 - Nested Formulas

Asked By GLENN ADAMS on 10-Aug-12 12:14 PM
I have 3 formulas that I need to put into a single function:

=SUBSTITUTE(A4,"-",".")
=SUBSTITUTE(A4,"A",11)
=SUBSTITUTE(A4,"B",12)

I want hyphens (-) to be recognized as decimals,
then I want "A" to be recognized as "11",
etc...
Any ideas?




Claus Busch replied to GLENN ADAMS on 10-Aug-12 12:36 PM
Hi Glenn,

Am Fri, 10 Aug 2012 09:14:26 -0700 (PDT) schrieb GLENN ADAMS:


try:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A4,"-","."),"A",11),"B",12)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
GLENN ADAMS replied to Claus Busch on 10-Aug-12 05:50 PM
Excellent!!! Right on the money. Have a Beer - you deserve it.
Glenn Adams