Using your posted workbook,
this regular formula returns the number from the end of the text
Is that something you can work with?![]()
E15: =IFERROR(LOOKUP(99^99,--RIGHT(B15,ROW(INDIRECT("1:"&LEN(B15))))),"")
Using your posted workbook,
this regular formula returns the number from the end of the text
Is that something you can work with?![]()
E15: =IFERROR(LOOKUP(99^99,--RIGHT(B15,ROW(INDIRECT("1:"&LEN(B15))))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks