Deleting text from cell A from cell B

[Gamermatt]

Hello,

I have a list of product numbers in column A, and a list of titles in column B. All the titles start with the product number, followed by a "-" ... I need to delete the product numbers, as well as the "-", from each title.

Example:
A1: BZ-9004-8
B1: BZ-9004-8-Boltz Japan HID Xenon Lighting System Conversion Kit 9004 Bulb Type 8000K White with Blue Ray Color

Then C1 should contain: Boltz Japan HID Xenon Lighting System Conversion Kit 9004 Bulb Type 8000K White with Blue Ray Color

Thanks.

Matt

 

[Weaver]

Try this formula in C1:

=MID(B1,LEN(A1)+2,LEN(B1))

 

[VoG]

Try

=SUBSTITUTE(SUBSTITUTE(B1,A1,""),"-","")

 

[Gamermatt]

Thanks!