I need a formula that will extract the text from a string with numbers preceding and following the text. i.e.
1C3, 12B4, 23STR6,
there may be 1 to 4 numbers preceding and following and 1 to 4 text characters.
It may also have text preceding the number like STR4 or G7.
I need the formula to be in say cell B1 and the string to be in A1.
A1 would have 12STR23 ant the result would be in B1 STR.