How to Flip Binary into Hex Private Key Using Excell or Spreadsheet

[Chikito]

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



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)

where A2,B2,C2,D2 are coin1-4 column


And then, Formula for convert binary into Hex [H column] is

Code:

=BIN2HEX(F2)

Where F2 is Binari column


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

[1715139975]

1715139975

[1715139975]

1715139975

[1715139975]

1715139975

[Chikito]

How to convert Hexadecimal to binary

Use this code to excel:

Code:

=HEX2BIN(A2)

where A2 is hex colomn



See spreadsheet here: https://docs.google.com/spreadsheets/d/12jKxquPrgIBqbL8qLLmUOXc451YGZdGUgyJP0R5PCFs/edit#gid=1406896737