I have hundreds of lines of data and need to consolidate the product numbers into generic product families.

A few examples:

RWH39585T339HBZ
RWH39585T339GDT
RWH39585T339R
RWH39585T339RTT

QW1410NHE
QW1410TRR
QW1410TB
QW1410X

F287387WW29384XT
F287387WW29384TOP
F287387WW29384R

On the third example, there are also letters between two number strings - these need to stay intact, as do the letters at the start of the chain.

I considered using the IF function to test if the last character on the right was a number or letter, and if it was a number then remove everything to the right of it by Substitution or using LEFT, but I'm not sure if this is possible to extract in this way.

Any help would be much appreciated.

Thanks, William