Substitute function
I'd like to get rid of "DES:MERCH SETL" and "CO".
COMPANY CO
I assume you want to retain the "CO" in COMPANY.
Try this (all on one line):
=TRIM(SUBSTITUTE(SUBSTITUTE(A1
," DES:MERCH SETL ","")," CO ",""))
--
Biff
Microsoft Excel MVP
"momotaro" wrote in message
...
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.
|