Filling a colun with a series of numbers

Closed
Marilyn - Jul 23, 2009 at 09:38 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 23, 2009 at 10:52 PM
Hello,

I am trying to copy a series of numbers that are labeled (example: 1, 1a, 1b, 1c) in 1 cell down a column as well as filling in the series of numbers (example: cell A1 - 1, 1a, 1b, 1c and cell - 2, 2a, 2b, 2c, etc) Can this be done? If so how?

Thanks so much
Marilyn

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 10:52 PM
Hello Marilyn

In one column in rows 2 onwards enter a,b,c etc
in first row of column B onwards enter 1,2,3 ...
In cells B2 enter the formula =B$1 & $A2 and drag
Copy the entire data and then paste special as values
0