Hi i have difficulties with Right and Find.
In a cell A1 to A20 i have;
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)
I can figure out why this is not working
In a cell A1 to A20 i have;
A1 Americas_variances 0.xlsm |
A2 Argentina_variances 1.xlsm |
A3 Bolivia_variances 0.xlsm |
A4 Brasil_variances 1.xlsm |
A5 BVI_variances 1.xlsm Etc |
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)
I can figure out why this is not working