The following text string is in column Z. When I try your formula it still
does not work for some of the CC types.

Rcpt Revsed as Remit Faild on 04/14/06. Orig Paym Detl -
PSON:BOB_21201653350 Orig Paymethd:DIR American Express C.Bnk:Credit Card
Bank Rtng#: Acct#:378300000000007 Exp Date:05/31/06 Ptech mesg:Processor
Decline

Rcpt Revsed as Remit Faild on 04/14/06. Orig Paym Detl -
PSON:BOB_31201652172 Orig Paymethd:DIR MasterCard C.Bnk:Credit Card Bank
Rtng#: Acct#:5490000000000000 Exp Date:10/31/06 Ptech mesg:Over Freq Limit

Rcpt Revsed as Remit Faild on 04/11/06. Orig Paym Detl -
PSON:BOB_13201523368 Orig Paymethd:DIR Visa C.Bnk:Credit Card Bank Rtng#:
Acct#:4388000000000000 Exp Date:04/30/07 Ptech mesg:Do Not Honor

Rcpt Revsed as Remit Faild on 10/04/05. Orig Paym Detl - PSON:BOB_20782906
Orig Paymethd:DIR Discover C.Bnk:Credit Card Bank Rtng#:
Acct#:6011000000000000 Exp Date:03/31/08 Ptech mesg:Do Not Honor



--
Thanks for your help!

Walter


"SteveG" wrote:


Ah. You didn't say that you had another card company in your OP. If
all of your text strings contain the name of the credit card company
within it somewhere then you could use this:


=IF(ISNUMBER(SEARCH("American Express",A1,1)),"American
Express",IF(ISNUMBER(SEARCH("Visa",A1,1)),"Visa",I F(ISNUMBER(SEARCH("Master
Card",A1,1)),"Master
Card",IF(ISNUMBER(SEARCH("Discover",A1,1)),"Discov er",0))))


Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=534652