[SOLVED] Excel match text only

[konio]

Hello,

I had the following formula (which works fine for exact matching):

=INDEX(B:B;MATCH(F2;A:A;0))

This time I need a partial match and not exact match. For example match "BO" from "BO635E30X". The scenario is always first text from left before numbers. Another example is "K" from "K5450X". It needs to always match the first letters before any numbers.

Your help will be much appreciated.

[AlKey]

Try something like this:
Enter formula in B1 and copy down

Please Login or Register  to view this content.

v	A	B
1	BO635E30X	BO
2	K5450X	K