Nesting the SUBSTITUTE formula
THANK YOU!
It works PERFECTLY!
"Biff" wrote:
Hi!
Try this:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"RUS","RUSTIC A"),"TOS","TOSCANA"),"GIA","GIADA")
Substitute is case sensitive.
Biff
"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!
|