Excel challenge – Binary to text

Your cryptic uncle has sent you a text message in binary and now you need to convert it back to a readable format.

First, you need to convert to a decimal value. To convert from binary to decimal we use the following formula:

decimal = d₀×2⁰ + d₁×2¹ + d₂×2² + …

The decimal number is equal to the sum of binary digits (d_n) times their power of 2 (2ⁿ)

Example:

Find the decimal value of 111001

1⋅2⁵+1⋅2⁴+1⋅2³+0⋅2²+0⋅2¹+1⋅2⁰ = 57

Then, use the conversion table to convert the decimal number to a character.

Write a formula in column G that converts the binary string into a character. The message can then be read from top to bottom.

Post your solution in the comments! 🙂

Our solution:

=XLOOKUP(A3*2^5+B3*2^4+C3*2^3+D3*2^2+E3*2^1+F3*2^0;$J$3:$J$29;$I$3:$I$29)