What I thought should be a simple task seems to be surprisingly difficult. Long story short, I need to find a simple method of having cells named after the column letters, all the way from A-XFD.
All of the methods I have found online have either just returned the column number instead of a letter, could not be used to autofill the entire list, or involved overcomplicated methods.
Goals:
-Cells A1-XFD1 named A-XFD respectively
-A simple formula or method of autofilling letters in the same pattern Excel uses for column lettering
If it turns out that the easiest method is simple for an advanced user, but difficult for a beginner user, I kindly ask for pity. If it can't be done with a simple formula, even just having access to an excel file with A1-XFD1 labelled appropriatley would allow me to copy and paste into files as needed as a decent workaround. Ive been trying to figure this out for far too long now and would greatly appretiate even just a workaround at this point.
Bookmarks