Results 1 to 4 of 4

Thread: autofill column with increments
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2018
    Posts
    267
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default autofill column with increments

    what is the formula to populate a column with alphanumeric string?
    the string is to be used as product code..
    say, starting at LFK101 - LFK102 - LFK103 (increment) so on down..
    the string can be any number of letters and numbers..
    like A1, ABC123, XYZ110.... the letter is always at the left and the numbers are at the right side of the string..
    maximum letter = 10; maximum number to reach = 10,000
    many many thanks
    Last edited by LFKim2018; Sep 11th, 2018 at 09:15 PM.

  2. #2
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: autofill column with increments

    Hi,

    You don't need a formula.

    Enter the First Product Code in cell, Select that cell, left click on the cell Handle (little "square" at lower right corner of cell) and drag down as far as you need:

    ABCDE
    1LFK101A1ABC123XYZ110JIWEHUISEV005
    2LFK102A2ABC124XYZ111JIWEHUISEV006
    3LFK103A3ABC125XYZ112JIWEHUISEV007
    4LFK104A4ABC126XYZ113JIWEHUISEV008
    5LFK105A5ABC127XYZ114JIWEHUISEV009
    6LFK106A6ABC128XYZ115JIWEHUISEV010
    7LFK107A7ABC129XYZ116JIWEHUISEV011
    8LFK108A8ABC130XYZ117JIWEHUISEV012
    9LFK109A9ABC131XYZ118JIWEHUISEV013
    10LFK110A10ABC132XYZ119JIWEHUISEV014

    Sheet248




  3. #3
    Board Regular
    Join Date
    Mar 2018
    Posts
    267
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: autofill column with increments

    just learned another!
    thank you very very much jtakw

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: autofill column with increments

    You're welcome.

Some videos you may like

User Tag List

Tags for this Thread

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
  •