Results 1 to 2 of 2

Thread: Formulas which help with sequential data

  1. #1

    Formulas which help with sequential data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to find a formula that helps me do this in several rows:
    4 rows of the info below:
    SO09102015a
    SO09102015a
    SO09102015a
    SO09102015a
    Followed by keeping the same letter and number format, but making the last character sequential in alphabetical order, so:
    SO09102015b
    SO09102015b
    SO09102015b
    SO09102015b
    SO09102015c
    SO09102015c
    SO09102015c
    SO09102015c

    and so on...I have over 200 rows of data that I really don't want to have to copy and paste. Dragging with the fill handle doesn't work either.

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the attachment.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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