Hi, basically I need a workflow that:
- Converts a number to Base 26 notation e.g. converts E to 5, 27 to AA, 52 to AZ, 53 to BA and so on.
- Does the inverse i.e. parses BA28 to column number 53, row 28… E30 to column 5, row 30 etc.
It should work with any length of column label e.g. A-Z, AA-ZZ, AAA-ZZZ and so on. So I can just shift right one cell and it switches from Z10 to AA10, or shift left one cell from BA11 to AZ11 etc.