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:
You could create a named lambda formula in your PERSONAL.XLSB workbook (or in an add-in).
You can do so without unhiding PERSONAL.XLSB by executing the following line in the Immediate window in the Visual Basic Editor:
Workbooks("personal.xlsb").Names.Add Name:="Split_Char", RefersTo:="=LAMBDA(a, MID(a, SEQUENCE(, LEN(a)), 1))"You can then use it as follows to split the value of A1 in any workbook:
=PERSONAL.XLSB!Split_Char(A1)
Thanks HansVogelaar , as an example:-
I tried an example as above, with normal formula ( in this case to extract txt after the last digit in each string) , it works without LET/LAMBDA, but when I use LAMBDA in Name-Manager, then it gives an Err as above in E2. Attached is the worksheet.
Thanks in Advance,
Br,
Anupam
