Forum Discussion
alex2476
Mar 14, 2022Copper Contributor
Number extraction Excel
So 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 doubled.
So the content of the cell above would appear in another cell as:
14, 20, 22
I've looked at this article:
https://www.ablebits.com/office-addins-blog/2016/06/01/split-text-string-excel/
I'm not sure it applies because they are numbers and because I don't know how many values id have in the original cell. So in this example there are 4 values in the original cell and 3 in the result cell. But the first cell could have any number of values.
Any help is appreciated
1 Reply
- Julian_SharpLearn ExpertYou have posted on the Microsoft Learn community board which is all about exams, certification and training. You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral