I want to create a series of numbers with text at the beginning and end of the number. For example, the data would start with "AA00001.FILE" and I want to increase the number inside the text by one as you move down the column.

AA00001.FILE
AA00002.FILE
AA00003.FILE

I've done this before without having to download any add-ins, I think it has something to do with the format of the cells but I can't seem to remember exactly what I did. Any ideas?

3/23/2007 9:35:52 AM

one solution would be to use multiple columns.
in Col A, start off with AA00001 in row 1, AA0002 in row 2. Then highlight them both and fill down and it will automatically increment the number.
then in Col B use a formula to concatenate Col A with your file extension, like =A1&".FILE"

3/23/2007 9:44:21 AM

Yeah, just figured it out. Thanks.

3/23/2007 9:50:25 AM

sql, ftw

3/23/2007 3:30:49 PM

sql > excel

but excel >> sql

3/23/2007 4:18:25 PM