Nesting the SUBSTITUTE formula
 

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!

Nesting the SUBSTITUTE formula
 

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!

Nesting the SUBSTITUTE formula
 

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!

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!

Nesting the SUBSTITUTE formula
 

THANK YOU!
It works PERFECTLY!


"Arvi Laanemets" wrote:

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!