How do I drag the sequence of letters/numbers?

Hi Everyone,

I'm working on a project where I have to set up new bin locations in a warehouse. I have an excel sheet and I want to use the drag function (where you highlight a cell or cells and grab the corner to drag it down) to complete a series of number/letters.

Here is the format I want to follow:

3MAA
3MAB
3MAC
3MAD

If I highlight these cells and then drag down it should go "3MAE, 3MAF" ect... But, it will not do this.

Any help is GREATLY appreciated as it will save me hours of typing!

Thanks,
Chris

Hi,

If you want to increment the 3rd character as well,

Put a list of numbers from 1 up in column A

in B1 =CHAR(64+ROUNDUP(A1/26,0))
in C1 =CHAR(64+(-(ROUNDUP(A1/26,0)-1)*26)+A1)
in D1 ="3M"&B1&C1

When copied down, column D will contain your references from 3MAA to 3MZZ

Dave