Excel : custom fill alphabetically

[Lemming Train]

Hi I'm trying figure out if there's a way of incrementing the cell data in each row by the next letter. I have cells to find starting with JAAA and ending at OZZZ.

Eg.

JAAA
JAAB
JAAC
...
OZZX
OZZY
OZZZ

My attempts at filling the first few cells and then selecting and dragging them southwards hoping that Excel would work it out and populate them all for you didn't work and instead just repeats the same ones at the start.

Thanks .

[Mr Pointy]

From your post it's not clear if you're building this list or working with an existing one but this may help if it's the former. I couldn't find a way of incrementing the last letter but there is away you can make it less painful than typing it all out by using the concatenate function.



Once you've typed out A-Z once you can simply copy & paste to re-use it in further rows. Note the cells in column E are still calculated so when you have created them all just do a copy/paste values to fix them.

Note you can create custom fill lists but it's of limited use in this case - see this page & scroll down to creating a custom series:

https://www.howtogeek.com/279148/how-to-automatica...

[Lemming Train]

Thanks. I did do exactly that for a previous batch but it was a little too time consuming for my liking. What made it annoying was trying to merge them into 1 cell when I'd finished. I tried all sorts of methods and all were adding unwanted formatting with spaces etc. In the end I found an add-on (this was working with Google Sheets rather than Excel) which merged them together so I got there eventually. I was not even aware of the CONCATENATE formula so knowing this now is particularly useful and I'll just crack on with the same method I used for the previous batch - thanks!

[snuffy]

Here you are:



it takes a few seconds to generate all 105,456 rows !!

[Lemming Train]

SNUFFY - thanks for that, but wtf do I do with it? And does it come in code tags rather than picture form or was that deliberate?

[snuffy]

Lemming Train said:

SNUFFY - thanks for that, but wtf do I do with it? And does it come in code tags rather than picture form or was that deliberate?

No, it comes in code form, but PH makes a pigs ear of the formatting ! (hence I posted a screen shot).

You don't really need the code once it's been executed once, just the spreadsheet with the output.

I've sent you PM, if you reply to that I'll send it to you.