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)

Found out myself..
=LEFT(RIGHT(C7,6),1)

Cross post without links http://www.excelguru.ca/forums/showt...ed=1#post23610

Read http://www.excelguru.ca/content.php?184

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post