| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
Hi All,
I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
No, you need to nest them.
-- HTH Bob "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
Nest not a function. It's just a description of putting one function within
another. So what you need is: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?"," "),"~","") Regards, Fred "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple str
The replace text argument could be blank as below
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",),"?",)," ~",) -- Jacob (MVP - Excel) "Fred Smith" wrote: Nest not a function. It's just a description of putting one function within another. So what you need is: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?"," "),"~","") Regards, Fred "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple str
Hi Bob,
Thank You, for spending some time on this. However my friend did this a long ago without Nesting it. He told me if your confident about the formula that you used and excel not returning the result. You need to copy the source data to the below cell and You need to use Ctrl+D Shortcut key to copy the formula from above cell, Then the formula should work. For example IF Cell C4=Raja~Mahendiran?#. I need to copy this data to C5 and IF Cell D4=SUBSTITUTE(C4,"~?#",""). I need to Use Ctrl+D. However what he said is not working!!! Could you please try the above or investigate on this Thank You, Raja Mahendiran S "Bob Phillips" wrote: No, you need to nest them. -- HTH Bob "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple str
Hi Fred,
Thank You, for spending some time on this. However my friend did this a long ago without Nesting it. He told me if your confident about the formula that you used and excel not returning the result. You need to copy the source data to the below cell and You need to use Ctrl+D Shortcut key to copy the formula from above cell, Then the formula should work. For example IF Cell C4=Raja~Mahendiran?#. I need to copy this data to C5 and IF Cell D4=SUBSTITUTE(C4,"~?#",""). I need to Use Ctrl+D. However what he said is not working!!! Could you please try the above or investigate on this Thank You, Raja Mahendiran S "Fred Smith" wrote: Nest not a function. It's just a description of putting one function within another. So what you need is: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?"," "),"~","") Regards, Fred "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple str
Hi Jacob,
Thank You, for spending some time on this. However my friend did this a long ago without Nesting it. He told me if your confident about the formula that you used and excel not returning the result. You need to copy the source data to the below cell and You need to use Ctrl+D Shortcut key to copy the formula from above cell, Then the formula should work. For example IF Cell C4=Raja~Mahendiran?#. I need to copy this data to C5 and IF Cell D4=SUBSTITUTE(C4,"~?#",""). I need to Use Ctrl+D. However what he said is not working!!! Could you please try the above or investigate on this Thank You, Raja Mahendiran S "Jacob Skaria" wrote: The replace text argument could be blank as below =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",),"?",)," ~",) -- Jacob (MVP - Excel) "Fred Smith" wrote: Nest not a function. It's just a description of putting one function within another. So what you need is: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?"," "),"~","") Regards, Fred "Raja Mahendiran S" <Raja Mahendiran wrote in message ... Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
