software

I need some help to create a nested quot;SUBSTITUTEquot; formula.

So far I was able to accomplish the substitution of only a part of the cell
content as following:
=SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTICAquot;)

RUS is the content of cell quot;A1quot; which is the short code for RUSTICA
RUSTICA is the formula result on B1

RUSRUSTICA

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

Content of cell quot;A1quot; 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!

Hi

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTIC Aquot;),quot;TOSquot;,quot;TOSCANAquot;),quot;GIAquot;
,quot;GIADAquot;)Arvi Laanemets
quot;Marco Margaritelliquot; gt; wrote in
message ...
gt; I need some help to create a nested quot;SUBSTITUTEquot; formula.
gt;
gt; So far I was able to accomplish the substitution of only a part of the
cell
gt; content as following:
gt; =SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTICAquot;)
gt;
gt; RUS is the content of cell quot;A1quot; which is the short code for RUSTICA
gt; RUSTICA is the formula result on B1
gt;
gt; RUS RUSTICA
gt;
gt; I would like a formula that would change THREE instances and that will
give
gt; me the following result:
gt;
gt; Content of cell quot;A1quot; is now
gt; RUS TOS GIA
gt;
gt; The nested SUBSTITUTE FORMULA should give me the
gt;
gt; RUSTICA TOSCANA GIADA
gt;
gt; which are the full name of the three above codes.
gt;
gt; THANK YOU!
Hi!

Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTIC Aquot;),quot;TOSquot;,quot;TOSCANAquot;),quot;GIAquot;,quot;GIADAquot;)

Substitute is case sensitive.

Biff

quot;Marco Margaritelliquot; gt; wrote in
message ...
gt;I need some help to create a nested quot;SUBSTITUTEquot; formula.
gt;
gt; So far I was able to accomplish the substitution of only a part of the
gt; cell
gt; content as following:
gt; =SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTICAquot;)
gt;
gt; RUS is the content of cell quot;A1quot; which is the short code for RUSTICA
gt; RUSTICA is the formula result on B1
gt;
gt; RUS RUSTICA
gt;
gt; I would like a formula that would change THREE instances and that will
gt; give
gt; me the following result:
gt;
gt; Content of cell quot;A1quot; is now
gt; RUS TOS GIA
gt;
gt; The nested SUBSTITUTE FORMULA should give me the
gt;
gt; RUSTICA TOSCANA GIADA
gt;
gt; which are the full name of the three above codes.
gt;
gt; THANK YOU!
THANK YOU!
It works PERFECTLY!quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTIC Aquot;),quot;TOSquot;,quot;TOSCANAquot;),quot;GIAquot;,quot;GIADAquot;)
gt;
gt; Substitute is case sensitive.
gt;
gt; Biff
gt;
gt; quot;Marco Margaritelliquot; gt; wrote in
gt; message ...
gt; gt;I need some help to create a nested quot;SUBSTITUTEquot; formula.
gt; gt;
gt; gt; So far I was able to accomplish the substitution of only a part of the
gt; gt; cell
gt; gt; content as following:
gt; gt; =SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTICAquot;)
gt; gt;
gt; gt; RUS is the content of cell quot;A1quot; which is the short code for RUSTICA
gt; gt; RUSTICA is the formula result on B1
gt; gt;
gt; gt; RUS RUSTICA
gt; gt;
gt; gt; I would like a formula that would change THREE instances and that will
gt; gt; give
gt; gt; me the following result:
gt; gt;
gt; gt; Content of cell quot;A1quot; is now
gt; gt; RUS TOS GIA
gt; gt;
gt; gt; The nested SUBSTITUTE FORMULA should give me the
gt; gt;
gt; gt; RUSTICA TOSCANA GIADA
gt; gt;
gt; gt; which are the full name of the three above codes.
gt; gt;
gt; gt; THANK YOU!
gt;
gt;
gt;

THANK YOU!
It works PERFECTLY!quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTIC Aquot;),quot;TOSquot;,quot;TOSCANAquot;),quot;GIAquot;
gt; ,quot;GIADAquot;)
gt;
gt;
gt; Arvi Laanemets
gt;
gt;
gt;
gt; quot;Marco Margaritelliquot; gt; wrote in
gt; message ...
gt; gt; I need some help to create a nested quot;SUBSTITUTEquot; formula.
gt; gt;
gt; gt; So far I was able to accomplish the substitution of only a part of the
gt; cell
gt; gt; content as following:
gt; gt; =SUBSTITUTE(A1,quot;RUSquot;,quot;RUSTICAquot;)
gt; gt;
gt; gt; RUS is the content of cell quot;A1quot; which is the short code for RUSTICA
gt; gt; RUSTICA is the formula result on B1
gt; gt;
gt; gt; RUS RUSTICA
gt; gt;
gt; gt; I would like a formula that would change THREE instances and that will
gt; give
gt; gt; me the following result:
gt; gt;
gt; gt; Content of cell quot;A1quot; is now
gt; gt; RUS TOS GIA
gt; gt;
gt; gt; The nested SUBSTITUTE FORMULA should give me the
gt; gt;
gt; gt; RUSTICA TOSCANA GIADA
gt; gt;
gt; gt; which are the full name of the three above codes.
gt; gt;
gt; gt; THANK YOU!
gt;
gt;
gt;