Nesting the SUBSTITUTE formula

[Guest]

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!

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets

 

[Biff]

Hi!

Try this:

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

Substitute is case sensitive.

Biff

 

[Guest]

THANK YOU!
It works PERFECTLY!

Hi!

Try this:

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

Substitute is case sensitive.

Biff

 

[Guest]

THANK YOU!
It works PERFECTLY!

Hi

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


Arvi Laanemets