Slit numbers from begining of text

Hi

I have lost the formula for this looked everywhere, I have Content that looks like this e.g 1dg, 15gh, 8fj, 20lk,

I reqiure the formula to split the number into another cell(numbers will be no more than 2 digits), I already have the formula for the letters.

Thanks

This is what i have not sure how i would go about it.

=IF(ISNUMBER(MID(K3,2,1)+1),MID(K3,3,10),MID(K3,2,10))

That works

Thanks Pal

Hi MATU70

if your letter contains 2 character and it is always preceded by number. try to use below formula

=MID(B3,1,LEN(RIGHT(B3,2))-1)

Regards,