+ Reply to Thread
Results 1 to 3 of 3

Help auto filling using column letters instead of numbers

  1. #1
    Registered User
    Join Date
    03-31-2019
    Location
    canada
    MS-Off Ver
    2007
    Posts
    2

    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. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    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))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    Re: Help auto filling using column letters instead of numbers

    OK, this works out all teh way to the end...
    =SUBSTITUTE(SUBSTITUTE(TEXT(CELL("address",A1),"x"),"$",""),1,"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to auto add with mix of numbers & letters
    By Franchesca in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2018, 05:08 PM
  2. Auto Filling Column
    By tammyp3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2016, 04:23 PM
  3. [SOLVED] Auto filling numbers - very basic, sorry!
    By Beatnik10 in forum Excel General
    Replies: 5
    Last Post: 08-25-2015, 06:29 AM
  4. Replies: 1
    Last Post: 08-27-2014, 11:05 AM
  5. Auto filling blank cells with a certain group of numbers.
    By Ranch1201 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2013, 11:27 AM
  6. Auto populate cells with numbers and letters?
    By quikrich3 in forum Excel General
    Replies: 2
    Last Post: 04-08-2011, 01:40 PM
  7. Auto generate numbers and letters as password
    By _bones_ in forum Excel General
    Replies: 1
    Last Post: 01-01-2010, 07:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1