Substitute function

  • Thread starter Thread starter momotaro
  • Start date Start date
M

momotaro

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.
 
hi,

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

if this helps please click yes, thanks
 
=TRIM(SUBSTITUTE(SUBSTITUTE(B6,"DES:MERCH SETL",""), "CO", ""))

You need to watch your brackets. Write one function and get it working and
then nest it in the next function...
 
I'd like to get rid of "DES:MERCH SETL" and "CO".
COMPANY CO
Click to expand...

I assume you want to retain the "CO" in COMPANY.

Try this (all on one line):

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