| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Substitute function
Can anyone help me to find out how to use substitute function? Here is my
example: Description: BANKCARD DES:MERCH SETL ID:1xxxxxxxxxxx,INDN:ABC COMPANY CO ID:1AAAAAAAAA CCD I'd like to get rid of "DES:MERCH SETL" and "CO". Here is my formula =TRIM(SUBSTITUTE(SUBSTITUE(B6,"DES:MERCH SETL","","CO","")) Any susgessions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Substitute' function with wildcards | Excel Discussion (Misc queries) | |||
| Substitute Function Question #2 | Excel Discussion (Misc queries) | |||
| SUBSTITUTE Function - Nesting Limitation | Excel Worksheet Functions | |||
| Substitute function | Excel Discussion (Misc queries) | |||
| Case function substitute | Excel Discussion (Misc queries) | |||
Threaded Mode
