TechSpot

Need Formula Help With Excel

By macx
Mar 26, 2006
  1. I guess I didn't pay enuf attention in algebra, but -

    I frequently have to work with columns of numbers
    that are sequential but also contain letters.

    I know how to do the formula for automatically
    entering sequential numbers, but how can that
    be done when the number also contains a letter.

    As in A1, A2, A3, etc. Short of putting them in
    separate narrow columns, there must be a formula
    for keeping the A constant or locked and increasing
    the numeric value in succeeding rows in a column.

    Thanks!
     
  2. TS | Thomas

    TS | Thomas TS Rookie Posts: 1,319

    Hi

    If I'm reading you correctly then what you can do is select several of these cells, e.g. A1, A2, A3, click on the right + sign at the bottom right of the last cell (Auto-fill), you can then drag this down for the amount of cells you want to carry the number down to - the A remains unchanged, but the numeric value will change accordingly.
     
  3. kirock

    kirock TS Rookie Posts: 1,221

    Try this:
    ="A"&VALUE(MID(A1,2,2))+1, A1 is the cell (the upper left most cell) which contains the value A1. You would put this formula in the cell A2, then you would copy A2 down the column the number of rows you need. If you are going to 3 digits, as in A120, then you need to use ="A"&VALUE(MID(A1,2,3))+1

    Or you could do what Thomas said.

    Cheers
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...