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

Sorry, formula is wrong. :( Gives skewed results.

With three blank columns to your data's right, in B1:D1 enter 97 in each
cell. Then in A2 enter:

=CHAR(B2)&CHAR(C2)&CHAR(D2)

In B2 enter:

=IF(C2=122,B1+1,B1)

In C2 enter:

=IF(D2=97,C1+1,C1)

In D2 enter:

=IF(D1=122,97,D1+1)

Copy all down as needed. Hide columns B:D if desired. Sorry for any
confusion again. :(

--
Regards,
Zack Barresse, aka firefytr


"zackb" wrote in message
...
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