An anonymous reader, let’s call him Gary, sent me instructions on how to create hexidecimal numbers that are 26 characters in length. Apparently these are useful for wireless LANs. More on my ignorance later.
You’ll need to load the Analysis Toolpack for both the RANDBETWEEN and the DEC2HEX functions. The upper limit used in the RANDBETWEEN function is the upper limit for the DEC2HEX function. Whenever you need a new code, F9 will do the trick.
Now, back to my ignorance. I set up my wireless LAN a couple of years ago. At the time I’m sure I understood why I needed some really long code, but I haven’t needed to change it since. Should I be changing it?
Anyway, I thought this was a pretty clever use of Excel, and definitely worthy of a post here (not much of a compliment, I know).