Need Formula Help With Excel

M

macx

Posts: 723   +3
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!
 
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.
 
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
 

Latest posts

Back