Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASimple but fun.
This one took me longer than i'm proud to admit. But, it was very rewarding to finally work it out!
My solution
Nice.
Hmm. Some interesting solutions. l went a little avant garde. I created a table of values for the alphabet and then fed that into the data stream. A few extra steps but I got there.
Fun challenge! I first tried using REGEX but quickly realized it wouldn't work easily. Decided to just check each letter in word2 that matches word1 and replace with a '-' if matches. Then checked which ones ended up with all '-' and correct # of letters. Not sure if this was most efficient, but it worked. Might be good candidate for a batch macro 🙂