Friday, April 1, 2016

Converting binary code to text in Excel

The Task

0100001101101111011011100111011001100101011100100111010000100000011101000110100001101001011100110010000001100010011010010110111001100001011100100111100100100000011000110110111101100100011001010010000001101001011011100111010001101111001000000111010001100101011110000111010000100000011101010111001101101001011011100110011100100000011100110111000001110010011001010110000101100100011100110110100001100101011001010111010000100000011100110110111101100110011101000111011101100001011100100110010100100000011100110111010101100011011010000010000001100001011100110010000001001101011010010110001101110010011011110111001101101111011001100111010000100000010001010111100001100011011001010110110000101110

Copy the binary code above into Excel and create formulas to convert it into readable text.


Notes

For those who don't know what they are seeing, I should probably help explain. Each sequence of eight ones and zeros (The first would be 01000011) makes up a binary value equivalent of 0 through 255. Each of these values corresponds to a character code known to Excel. The first would be a capital C. I still don't want to give away too much, so I hope that's a good enough starting point.

Feel Free to Comment

Try to find your own unique approach and share what you are doing in the comments section. These comments can help you and others find new ideas to explore. If you are desperate enough and can't figure out how to accomplish this task, you can always ask. I do not provide storage to those who visit my blog. If you would like to share any files, you are going to have to find your own online storage. At that point, you can provide links with your comments. I would like to point out that macros can create security risks. If possible, save all documents as a standard workbook (not macro-enabled) unless macros are vital to your solution. If you are going to download any solutions, make sure that you are not loading macros by default. If a spreadsheet includes macros, check the code before running them.

Follow-up

No comments:

Post a Comment