Forum Discussion

alex2476's avatar
alex2476
Copper Contributor
Mar 14, 2022

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

 

 

 

Resources