Hi i have difficulties with Right and Find.

In a cell A1 to A20 i have;
A1 Am 0.xlsm

In cell B1 I want only the 0 or 1 from the above.

Of course i can do =RIGHT(C7,6)
but that gives me "0.xlsm"



I want only the 0 or 1 or what stands before the "."

Something like this (but that only goes well till B2
=RIGHT(FIND(".",A1,6)-1)