Results 1 to 4 of 4

autofill using alpha & numeric characters?

This is a discussion on autofill using alpha & numeric characters? within the Excel Questions forums, part of the Question Forums category; I need help! I know how to autofill with just numbers (ie: 0100001, 0100002, 0100003). But I cannot figure out ...

  1. #1
    New Member
    Join Date
    Dec 2003
    Posts
    1

    Default autofill using alpha & numeric characters?

    I need help! I know how to autofill with just numbers (ie: 0100001, 0100002, 0100003). But I cannot figure out how to autofill (if you can even do it) with both numbers and letters (ie: FS0400001, FS0400002, etc). I actually need 2 of each "number" (FS04000001, FS0400001, FS0400002, FS0400002, etc). I'm looking for something simple - drag & fill, cut/paste....no fancy formulas please . Edited to add that I need it in a column not rows. TIA!!

    Thank you for any help you can give me.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    2,317

    Default Re: autofill using alpha & numeric characters?

    Try this formula in B3

    ="FS0" & VALUE(RIGHT(A2,8))+1

    and this in B4

    ="FS0" & VALUE(RIGHT(A3,8))

    Then select B3 & B4 and drag downwards...


    ******** ******************** ************************************************************************>
    Microsoft Excel - Book11___Running: xl2000 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    FS04000001
    2
    FS04000001
    3
    FS04000002Select B3 & B4 and drag downwards
    4
    FS04000002
    5
    FS04000003
    6
    FS04000003
    7
    FS04000004
    8
    FS04000004
    9
    FS04000005
    10
    FS04000005
    11
    FS04000006
    Sheet6

    [HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    Board Regular santeria's Avatar
    Join Date
    Oct 2003
    Location
    Tallahassee
    Posts
    1,844

    Default Re: autofill using alpha & numeric characters?

    Well, I tried it in Columns.

    Typed in FSO4000001
    then dragged the box thingie ( technical term ) down to FSO4000022 down the column, works perfectly.

    Okay, my mistake... so you need two sets of numbers... silly me...


    Okay, I just tested with Two number values along side of each, works, sort of , but the first number stays the same, and the second number increments... I guess you could always concatenate ??


    "Don't Ruin an Apology with an Excuse"...

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    2,317

    Default Re: autofill using alpha & numeric characters?

    PS. After you have dragged downwards, you could copy >pastespecial>values to change to values...

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