Nested Formulas

  • Thread starter Thread starter GLENN ADAMS
  • Start date Start date
G

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?
 
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)
Click to expand...

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

Regards
Claus Busch
 
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
Click to expand...

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