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
    32,798
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    17 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,634
    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
    32,798
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    17 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

Some videos you may like

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
  •