Formula to extract number after dot in a cell

[Older Excel Learner]

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)))),"")

 

[Marcílio_Lobão]

Older Excel Learner, Good morning.

I'm really curious to know why you had to use this formula to get the left part of your information.

Try to use these formulas:

Left cell part:
=LEFT(S10, SEARCH(".", S10)-1)

Right cell part:
=MID(S10, SEARCH(".",S10)+1, 100)

Please, tell us if it worked as you desire.
I hope it helps.

 

[Older Excel Learner]

Thanks Marcilio for replying, It takes into account other things.

Could you just amend my original formula if ossible.

Thanks.

 

[Marcílio_Lobão]

Older Excel Learner,

"...Could you just amend my original formula if ossible...."
Ok. No more comments. We are here to help.

Just change the indicator 1 to 99.

Before:
=IF(COUNTIF(S10:S10,"?*"),SUMPRODUCT(0+(0&TRIM(MID(SUBSTITUTE(S10:S10,".",REPT(" ",99)),1,99)))),"")

Now:
=IF(COUNTIF(S10:S10,"?*"),SUMPRODUCT(0+(0&TRIM(MID(SUBSTITUTE(S10:S10,".",REPT(" ",99)),99,99)))),"")

I hope it helps.

 

[Older Excel Learner]

Thank You So Much. I have sent you a PM by way of explanation. Thanks again, greatly appreciated.

 

[Marcílio_Lobão]

Older Excel Learner, Good afternoon.

I'm glad to have helped you with your doubt.

Have a nice day!