Nested Formulas

[GLENN ADAMS]

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]

Hi Glenn,

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

I have 3 formulas that I need to put into a single function:

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

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

Regards
Claus Busch

 

[GLENN ADAMS]

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

Excellent!!! Right on the money. Have a Beer - you deserve it.
Glenn Adams