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

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

Try this (all on one line):

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top