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