Forum Discussion

Copper Contributor

Mar 18, 2022

Number Extraction Excel

I have a cell with theses values: 14.19, 14.36, 20.22, 22.23A I would like to have a formula that would extract each of the numbers before the periods and eliminate whatever values are doubl...

excel

Formulas and Functions

Starrysky1988

Iron Contributor

Mar 18, 2022

Textsplit function is currently available to users running Beta Channel, Version 2203 (Build 15104.20004) or later on Windows and Version 16.60 (Build 22030400) or later on Mac.

=LET(a,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),b,CONCAT(IF(CODE(a)>64,"",a)),c,FLOOR(VALUE(TEXTSPLIT(b,", ")),1),TEXTJOIN(", ",,UNIQUE(INDEX(c,ROW(INDIRECT("1:"&SUM(FREQUENCY(c,c))))))))

alex2476
Copper Contributor
Mar 19, 2022
I don't know if i have the right version i just run the regular Office36. but ill take a look at that function.