i have lots of Hexadecimal data till row 20000 , here i posted few of them for example,my query is like listed below 
A1=000000000000 200080000000
B1=000000000000 000080000000
C1=000000000000 010080023000
D1=000000000000 200080000000
E1=000000000400 000000000000
F1=00000000C000 000000000000
1st Step: i need to delete all zero & space from left side then it will be look like below
A1=200080000000
B1=80000000
C1=10080023000
D1=200080000000
E1=400000000000000
F1=C000000000000000
reff: for my project i already got partial update by below link

http://www.excelforum.com/excel-prog...57#post3107857

now i want to go forward with new step (actually i want to do my job step by step so that i can express my issue to all clearly)

2nd step: now i need to convert above data from Hexadecimal to Binary which are like following
G1=1000000000000010000000000000000000000000000000
H1=10000000000000000000000000000000
I1=10000000010000000000000100011000000000000
J1=1000000000000010000000000000000000000000000000
K1=10000000000000000000000000000000000000000000000000000000000
L1=1100000000000000000000000000000000000000000000000000000000000000
actually i do it manually with the help of website as following but it is very bothering job for me!!

http://www.binaryhexconverter.com/he...nary-converter

3rd step: i will let you know later !!