EXtract ALphanumeric from text string

Hi sktneer,

Thanks for the feedback. Bascially what I am looking for is to extract the last account number (sub account) of the text string.
In this Text string: 613000 · Non Income Tax Expense:613005 · Property Tax Expense:613005A · Property Tax Expense (CS)

It is viewed as such:-
613000 · Non Income Tax Expense
∟ 613005 · Property Tax Expense
∟ 613005A · Property Tax Expense (CS)

So 613005A is my expected result.

Hope this clarifies.

This is clunky play, but FWIW ....
Place in
K2: =SEARCH(":",A2,L2+1)
L2: =SEARCH(":",A2,M2+1)
M2: =SEARCH(":",A2)
N2: =INDEX(K2:M2,MATCH(TRUE,INDEX(K2:M2<>"#VALUE!",),0))
O2: =MID(A2,N2+1,7)
P2: =IF(ISNA(O2),LEFT(A2,7),O2)
Q2: =IF(ISNUMBER(LEFT(P2)+0),P2,MID(A2,M2+1,7))
Copy K2:Q2 down to Q13. Col Q seems to deliver the indicated results ....
---------------------------
Any good? Wave it, click on the little star at the bottom left of my responses