Hi Andrew-R
excellent job, i appreciate your macro logic

However my final destination is something like below

G1=1000000000000010000000000000000000000000000000

from right side of binary code, here i got 31 zero ("0") till first "1" so results in cell M1 will be 31
again i will be counting from right side of binary code till last left "1" no i am getting 45 (please notice that this time
i ignore middle "1", here i treat it as zero ("0"), so if i treat middle one ("1") is zero , then total zero is 45 so results
in the cell N1 will be 45)

now what will happened if the binary is like below

10000000010000000000000100011000000000000

1st step:CELL M1 will be 12 (as from right side we have 1000000000000 i.e 12 Zero till "1")
2nd step:CELL N1 will be 13 (for 2nd time from right side we have 11000000000000 i.e 13 in this time i treat "1" as zero "0" )
3rd step:CELL O1 will be 17 (100011000000000000 it will be 17 as middle both "1","1" i treat as "0","0", so total zero is 17)
4th step:CELL p1 will be 31 (10000000000000100011000000000000 so total zero is 31 as all middle "1" is zero , so total zero 31)
5th step:CELLQ1 will be 40 (10000000010000000000000100011000000000000 so total zero is 40 , as all middle "1" is "0" so total zero 40)

summery:
I1=10000000010000000000000100011000000000000

so from above binary i will be getting like below
M1=12
N1=13
O1=17
p1=31
Q1=40

last step: i will let you know later, it is some thing vlookup from other sheet as 12,13,17,31,or 40 etc having individual meaning !!!!