Nesting the SUBSTITUTE formula

M

Marco Margaritelli

I need some help to create a nested "SUBSTITUTE" formula.

So far I was able to accomplish the substitution of only a part of the cell
content as following:
=SUBSTITUTE(A1,"RUS","RUSTICA")

RUS is the content of cell "A1" which is the short code for RUSTICA
RUSTICA is the formula result on B1

RUS RUSTICA

I would like a formula that would change THREE instances and that will give
me the following result:

Content of cell "A1" is now
RUS TOS GIA

The nested SUBSTITUTE FORMULA should give me the

RUSTICA TOSCANA GIADA

which are the full name of the three above codes.

THANK YOU!
 
A

Arvi Laanemets

Hi

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"RUS","RUSTICA"),"TOS","TOSCANA"),"GIA"
,"GIADA")


Arvi Laanemets
 
B

Biff

Hi!

Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"RUS","RUSTICA"),"TOS","TOSCANA"),"GIA","GIADA")

Substitute is case sensitive.

Biff
 
M

Marco Margaritelli

THANK YOU!
It works PERFECTLY!


Biff said:
Hi!

Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"RUS","RUSTICA"),"TOS","TOSCANA"),"GIA","GIADA")

Substitute is case sensitive.

Biff
Click to expand...
 
M

Marco Margaritelli

THANK YOU!
It works PERFECTLY!


Arvi Laanemets said:
Hi

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"RUS","RUSTICA"),"TOS","TOSCANA"),"GIA"
,"GIADA")


Arvi Laanemets
Click to expand...
 
Top