Hello,

I suggest to put your numbers on the right side of your characters
(with a helper column, for example) and to use my UDF vlookupall() from
http://www.sulprobil.com/html/vlookupall.html

Then use something like
=vlookupall("a",B1:C9,2)
for example

HTH,
Bernd