Forum Discussion
Solved
Extracting numbers before string characters start
Hi all, I am looking for an excel formula that can help me to extract numbers only from a mix of numbers and characters ONLY before the first character starts (i.e sometimes there are numbers aft...
Presuming your text is in A2, you might use:
=LEFT(A2,MIN(IFERROR(SEARCH(CHAR(SEQUENCE(26,,65,1)),A2),""))-1)
Or, just because I find it difficult ...
WorksheetFormula
= SelectNumλ(@target);
SelectNumλ
= LAMBDA(t, [s],
LET(
n, LEN(t),
x, LEFT(t, 1),
y, RIGHT(t, n - 1),
d, ISNUMBER(VALUE(x)),
IF(d, SelectNumλ(y, s & x), s)
)
);a recursive Lambda!
In general optional parameter is not required, something like
getNumber= LAMBDA( str, IF( ISERROR( --LEFT(str,1) ), "", LEFT(str,1) & getNumber( RIGHT( str, LEN(str) - 1) ) ) );
