Forum Discussion
Solved
How to create a Custom formula in the Custom-Ribbon, instead of Name-Manager
Dear Experts, For example, if I have to split a string into Char and numbers, I used a Custom formula using LET as below in the "Name Manager" Problem with this is that we ca...
The definition of textafterlastdigit should be:
=LAMBDA(a,TEXTAFTER(a, SEQUENCE(10,,0),-1,,,""))
See the attached version:
The old 'Explode' Lambda certainly works but there's an easier way if you have access to Regex:
=REGEXEXTRACT(A1,".",1)The "." indicates any character. "1" is telling Excel to return each instance of any character which converts scalar to array.
Thanks Patrick, this regex function seems a life saver in excel, but unfortunately in our company IT desk doesn't enabled it :( in excel.