Title: How to Flip Binary into Hex Private Key Using Excell or Spreadsheet Post by: Chikito on December 05, 2019, 01:22:07 AM I flipping 256x coin and make a binary and convert it to Hex 64 Bitcoin private key using excel or spreadsheet
1100 = C 0010 = 2 0101 = 5 1011 = B 0101 = 5 1110 = E 1010 = A 0011 = 3 1010 = A 1101 = D ... ... Full Spreadsheet Here (https://docs.google.com/spreadsheets/d/12jKxquPrgIBqbL8qLLmUOXc451YGZdGUgyJP0R5PCFs/edit#gid=0) https://i.ibb.co/sQ82dRh/1.png You can do it for your self with excel offline on home, here the code: The formula for F binary column is Code: =CONCATENATE(A2,B2,C2,D2) And then, Formula for convert binary into Hex [H column] is Code: =BIN2HEX(F2) next, Hex privkey [k column] formula is Code: =CONCATENATE(H2,H3,H4,H5,H6,H7,H8,H9,H10,H11,H12,H13,H14,H15,H16,H17,H18,H19,H20,H21,H22,H23,H24,H25,H26,H27,H28,H29,H30,H31,H32,H33,H34,H35,H36,H37,H38,H39,H40,H41,H42,H43,H44,H45,H46,H47,H48,H49,H50,H51,H52,H53,H54,H55,H56,H57,H58,H59,H60,H61,H62,H63,H64,H65) Here Spreadsheet for You, you can edit flip : https://docs.google.com/spreadsheets/d/1NqJ1enUWL4diMVPXGa2jshLlm8qQw-avRJdoaTsx0eQ/edit?usp=sharing I am played flip to make Bitcoin Adress with my Son here (https://bitcointalk.org/index.php?topic=5205729.0) Title: Re: How to Flip Binary into Hex Private Key Using Excell or Spreadsheet Post by: Chikito on December 06, 2019, 12:07:42 AM How to convert Hexadecimal to binary
Use this code to excel: Code: =HEX2BIN(A2) https://i.ibb.co/cxTcmwv/2.png See spreadsheet here: https://docs.google.com/spreadsheets/d/12jKxquPrgIBqbL8qLLmUOXc451YGZdGUgyJP0R5PCFs/edit#gid=1406896737 |