Increment Letters (A+1 = B) - Page 3
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Increment Letters (A+1 = B)

  1. #21
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    31,211
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Increment Letters (A+1 = B)

     
    @ukmikeb, bosco_yip, István Hirsch,

    Are you all replying to the question asked in Message #15? As I read that question, the OP does not want AA, AB, etc. to follow Z; rather he wants ZA, ZB, etc. to follow it (and then ZZA, ZZB, etc. to follow ZZ, and so on).
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  2. #22
    Board Regular
    Join Date
    May 2013
    Posts
    1,593
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Increment Letters (A+1 = B)

    Quote Originally Posted by István Hirsch View Post
    Or try this:

    =SUBSTITUTE(ADDRESS(1,ROW(),4),1,"")
    I see now there were similar solutions before.

  3. #23
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    31,211
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Increment Letters (A+1 = B)

    Quote Originally Posted by István Hirsch View Post
    I see now there were similar solutions before.
    I think that is because you (and the other recent posts) are not answering the latest question posed in this thread. See my comments in Message #21 for more on this.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  4. #24
    Board Regular
    Join Date
    Jul 2009
    Location
    Woking UK
    Posts
    2,748
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Increment Letters (A+1 = B)

      
    Quote Originally Posted by Rick Rothstein View Post
    @ukmikeb, bosco_yip, István Hirsch,

    Are you all replying to the question asked in Message #15? As I read that question, the OP does not want AA, AB, etc. to follow Z; rather he wants ZA, ZB, etc. to follow it (and then ZZA, ZZB, etc. to follow ZZ, and so on).
    Rick

    In post #16 I realized the error that I had made in post #15 and satisfied the intermediate requirement.

    At that point I was pondering the final requirement which you have answered so economically.
    Mike

    -----------------------------------------------
    Some solutions don't require an IF!

    When posting code wrap your code between [CODE] tags, eg. [ code ] your code [ /code] - no spaces .

    Paste your Excel data...

    MrExcel HTML Maker or Excel Jeanie

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com