Transform a title to numbers to generate a unique code|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi All,

i am struggling for a time to create something like;

suppliers sending me their product lists, can be build up like;

'Apple 5KG  16-20 Jonagold extra red' 
some spaces, some numbers, some delimiters.

Is there a way i can turn this into a number, so i can map them towards our assortment and import their order.

actually a ' A=1 B=2' kinda thing could work i hoped for.
I attached a file with title examples.

Thanks in advance,