hi,

=TRIM(SUBSTITUTE(SUBSTITUTE(A1,"DES:MERCH SETL",""),"CO",""))

if this helps please click yes, thanks

"momotaro" wrote:

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.