Right find

[Fean]

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)

[Fean]

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

[Pecoflyer]

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

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