Challenge #372: A Header Reference Dataset from Excel Header Reference Letters

[bwins]

Spoiler

[CSmith16]

Kinda wish there were academy videos to introduce us to the functions most people used (Mod(), CharFromInt(), etc.). Kind of makes the whole "intermediate" difficuty shoot to advanced when you don't even know those functions in the solution even existed or how to use them. Instead, I did this the long, slow, messy way and used a multi row formula and a VERY long if statement to replace the number with alphabetical characters. Maybe there is a way to see what functions do what (aside form hovering over it to get a very generalized brief summary) but, I do not know it if there is. Anyways, here's my mess.

Spoiler

[JamesCharnley]

Could have done in one formula I guess but split it out (still unable to post screenshots)

[hlee36]

Attached is my solution.

[RWvanLeeuwen]

close enough

Spoiler

[OzlemSigbeku]

Reminded me of the ROT13

Spoiler

 

[elaineyuan]

I learned the CharFromInt function from this challenge! 

Spoiler

[boglarkalipka]

solved

[SylwiaDragon]

This was a fun one, done!

[Desmond]

My Solution