Older Excel Learner
New Member
- Joined
- Feb 3, 2018
- Messages
- 12
The formula below extracts the first of two different numbers in a single cell that are seperated by a . (dot, full stop, period)
So if I have 20.4 in a cell , it will extract any number to the left of the dot, in this example 20
Can somebody alter the formula to extract any number to the right of the dot, in this example 4
The formula is perfect for me I just don't know what to change within it for it to select right of dot instead of left of dot
Thanks.
=IF(COUNTIF(S10:S10,"?*"),SUMPRODUCT(0+(0&TRIM(MID(SUBSTITUTE(S10:S10,".",REPT(" ",99)),1,99)))),"")
So if I have 20.4 in a cell , it will extract any number to the left of the dot, in this example 20
Can somebody alter the formula to extract any number to the right of the dot, in this example 4
The formula is perfect for me I just don't know what to change within it for it to select right of dot instead of left of dot
Thanks.
=IF(COUNTIF(S10:S10,"?*"),SUMPRODUCT(0+(0&TRIM(MID(SUBSTITUTE(S10:S10,".",REPT(" ",99)),1,99)))),"")