Challenge #177: Ham Hamlet

[JBevan89]

Thank goodness I had not heard at the time of this 24 hour hackathon....would have been painful

[Carolyn]

Solved! I started by figuring out the vowels and then trying to figure out the most common consonants in 2 letter words that start with a vowel - "of" "on" etc. I was doing okay but then I ended up with saying "this one is either T or R or S - let me list them all in the Text Input file since one is going to be right". After a bit of that, I finally gave up and went with brute force (details in the spoiler)

Spoiler

I generated a list of all letters A-Z & a-z. I took the list of all the 2 letter combos and appended it to my alphabet list. I ran that through the macro and figured that at least 26 of them would be correct, which would unlock the macro

[SteveY02]

just curious, how many times do you use to split this string? I've alreday run 45 mins, still runing. Is this crazy?

[Erin]

I added a Step column to my cypher table so that it would be easy to walk through this step-by-step if trying to walk through this from the beginning. 

Spoiler

Big yuge THANK YOU to @T_Willins because I could not have completed this one without the logic you posted on how you solved this. I literally took a screenshot of your post and put it on my canvas as a guiding north star. Also, thanks to @Carolyn for putting up with my texts as I complained the whole way through this one. But I finally got it!!!!