View Single Post
  #2   Report Post  
zackb
 
Posts: n/a
Default

Hi there,

You can do this with some formulas. I'll assume you have this in A1 "aaa".
Enter this formula in A2 and copy down as needed ...

=IF(LEFT(A1,1)=122,CHAR(B1+1),CHAR(B1))&IF(MID(A1, 2,1)=97,CHAR(C1+1),CHAR(C1))&IF(RIGHT(A1,1)=122,CH AR(97),CHAR(D1+1))

--
Regards,
Zack Barresse, aka firefytr



"tadpgk835" wrote in message
...
I am looking to fill a series of increasing letters for example:

aaa
aab
aac
..
..
aaz
aba
abb