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.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…