Hi

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


Arvi Laanemets



"Marco Margaritelli" wrote in
message ...
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!