Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Dec 22, 2024
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...
  • HansVogelaar's avatar
    Dec 24, 2024

    The definition of textafterlastdigit should be:

    =LAMBDA(a,TEXTAFTER(a, SEQUENCE(10,,0),-1,,,""))

    See the attached version:

Resources