# Help auto filling using column letters instead of numbers

1. ## Help auto filling using column letters instead of numbers

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.

2. ## Re: Help auto filling using column letters instead of numbers

Hi, welcome to the forum

Why on earth would you want to show the col letters that far out, that is 16 384 columns?

This will get you out to ZZ...
=IF(COLUMNS(\$A\$1:A1)<27,"",CHAR(INT(65+(COLUMNS(\$A\$1:A1)-1)/26)-1))&CHAR(65+MOD(COLUMNS(\$A\$1:A1)-1,26))

3. ## Re: Help auto filling using column letters instead of numbers

OK, this works out all teh way to the end...

There are currently 1 users browsing this thread. (0 members and 1 guests)