Create an alphanumeric sequence

I want to create a 4 character alphanumeric sequence. The sequence is to be like this: a1a1-z10z10. If it's a number, increment 1 until you reach 10, then move to the next column, if it's a letter, increment a until z, then move to the next column. Excel's autofill feature doesn't seem to work well for me due to the letters involved, so if someone has a macro handy that would be great.

Thanks in advance for any help.

Please create a more distinctive sample in an actual workbook. Mock it up manually so it is visibly clear what you're goal is.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

Please create a more distinctive sample in an actual workbook. Mock it up manually so it is visibly clear what you're goal is.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

In A1,

= ADDRESS( MOD( INT(COLUMN() - 1) / 26, 10) + 1, INT( (COLUMN() + 259) /260), 4)
& ADDRESS(ROW(), MOD(COLUMN()-1, 26) + 1, 4)

Copy down to A10 and across to column IYZ.

So for the first column I want it to list a1a1-a1a10 and then in the second column a1b1-a1b10 and so on

That's what you asked for ...

Please Login or Register  to view this content.

deleted..deleted

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.