Tags Tags

Nested Formulas

August 10th, 2012 - 12:14 pm ET by GLENN ADAMS | Report spam
Help Create a new topic
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?
email Follow the discussionReplies 2 repliesReplies Make a reply

Similar topics

Display all similar topics

Replies

#1 Claus Busch
August 10th, 2012 - 12:36 pm ET | Report spam
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
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Replies Reply to this message
#2 GLENN ADAMS
August 10th, 2012 - 05:50 pm ET | Report spam
On Friday, August 10, 2012 12:36:55 PM UTC-4, Claus Busch wrote:
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


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
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search