LinkBack URL
About LinkBacks
If the part numbers are in A2 down, and the suffixes to be removed are in a range called Sfx, then in B2 and copy down,
=IFERROR(LEFT(A2, LEN(A2) - LEN(INDEX(Sfx, MATCH(TRUE, RIGHT(A2, LEN(Sfx) ) = Sfx, 0)))), A2)
This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.
The suffixes MUST be arranged in descending order by length. Otherwise, you might truncate only E4 from a part number whose last letters are RE4.
Register To Reply
Thanks so much. I completely forgot that I have 2 exceptions to the list of part number endings. PARGT & KTT These 2 exceptions do not need to have the "T" eliminated. so for instance in part number MESPT92375KTT it needs to be left alone, and not have the last "T" eliminated. I appreciate your help! 
Bookmarks