| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
