One of my columns is class e.g. A1, A2, A3 etc i.e a letter plus a number with no space between them.
If I enter A1 and then click on the little + in the corner and drag it down, Excel increments the number A2, A3. A6 etc. which I don't want.
I tried to copy the cell amd paste it into selected cells but it did not work.