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:
Thanks HansVogelaar , Sorry I didn't understood fully, yes this is what my goal is to get it in an addin
I attach the spread sheet, as an example, can you please help share the steps on how you add it to say the Addin "Anupam_Tools",
Or any simple lambda formula, intent is to understand how we bring this inbuilt/Custom formula to my "Anupam_Tools" the custom ribbon
Thanks in Advance,
The lambda formula is
=LAMBDA(a, MID(a, SEQUENCE(, LEN(a)), 1))
I don't think adding it to a custom ribbon tab is a good idea.