Formula

[Shepdawg]

I am trying to get one coloum to repeat and add one number each time, but the
catch is that I have a letter designation at the beginning and followed by a
dash and the last two digits of the year. And I need the number to keep the
three digits. I am using this to print and keep stats for the year for
reports. Like so: D001-09 the next should be D002-09, D003-09,
D004-09...ect. Then I want to be able to change it to a M or E designation
so it would be M001-09, M002-09... or E001-09, E002-09...ect. Is this even
possible with Excel 2003?

 

[Eduardo]

Hi,
Let's say in A2 you enter the letter you want i.e. D
in A3 you have '001 in B3 enter

=+$A$2&A3& "-" &9

then drag down A it will create 002,003 etc, copy down the formula in B
Hope this help

 

[Glenn]

I am trying to get one coloum to repeat and add one number each time, but the
catch is that I have a letter designation at the beginning and followed by a
dash and the last two digits of the year. And I need the number to keep the
three digits. I am using this to print and keep stats for the year for
reports. Like so: D001-09 the next should be D002-09, D003-09,
D004-09...ect. Then I want to be able to change it to a M or E designation
so it would be M001-09, M002-09... or E001-09, E002-09...ect. Is this even
possible with Excel 2003?

With D001-09 in A1, put the following in A2 and copy down:

=LEFT(A1,1)&RIGHT("00"&MID(A1,2,3)+1,3)&RIGHT(A1,3)