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

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

Formula Tool
  Name2 = ToNumber(Replace([Name], "Field_", ""))
  Mod26 = Mod([Name2], 26)
  Div26 = CEIL([Name2]/26)-1
  Char1 = IF [Div26]=0 THEN "" ELSE CharFromInt(64+[Div26]) ENDIF
  Char2 = IF [Mod26]=0 THEN "Z" ELSE CharFromInt(64+[Mod26]) ENDIF

  Column Letter = [Char1]+[Char2]

[Robinvm]

Spoiler

[bkclaw113]

---

Spoiler

[Tgigs]

Here is my solution

[Qiu]

Practical one!

Spoiler

[elena_mazareanu]

Solved

[ejhaley]

This one was quite fun! Did a step-by-step walk through as well.

Spoiler

[WaltReed]

This one was fun. Got it done in 3 steps. Tricky part was the formula for converting number to letter

Spoiler

 

 

[myastarling]

Here's my solution. I learned a new function today! :-)

[rbrown]

Definitely not the most efficient way, but it got to the destination