In cell A1 I have two variables...E1L1, EJ10L10(for example)

I would like in cell B1 the information before the character after the first series of numbers...These characters can vary in length

So If A1 equals E1L1...then B1 equals E1

If A1 equals EJ10L10...then B1 equals EJ10

Seeing that the string of characters can vary a simple character from beginning extraction would not be suitable

I'd prefer to do it with just a formula, but if a macro must be incorporated in the formula...That'd be acceptable