formula

[rhr9357]

if cell # e1 contains the words paymentech or american express and any letters or numbers that follow thwm then enter the value of cell c2

 

[MrKowz]

I answered this question in the other thread you created:

http://www.mrexcel.com/forum/showthread.php?t=531674

Per forum rules, please do not create duplicate threads. (see Rules 22 and 23)

 

[Joe4]

Please do not post the same question multiple times.
Per forum rules, posts of a duplicate nature will typically be locked or deleted.