formula to delete alpha value from another cell containing an alpha value

[liamtimms1985]

hi im new here and i am desperately trying to devise a formula in excel 2002 to split a product code... now there is not much consistancey in the codeds except the colour codes which i can identify

example
A B
1 ABC123BLK BLK
now i can split the colour from the original code but i need a formula to delete that colour codein B from the original code in A leaving the product code

result
A B
1 ABC123 BLK

because some of the codes vary in size i cant do a text to columns or right/left formula

i wish it was as easy as =A1-B1

if anyone can help i would be greatly appreciated

Many Thanks

Liam

[Ron Coderre]

With
A1: a product code, ending with a color....ABC123BLK
B1: a color code to remove from the product code...BLK

This formula removes the color code from the end of the product code
C1: =LEFT(A1,LEN(A1)-LEN(B1))

This one removes the color code wherever it exits in the product code:
C1: =SUBSTITUTE(A1,B1,"")

Note: if the product code is something like ABCBBLK123BLK
the first formula will return: ABCBBLK123
the second formula will return: ABCB123

Does that help?