I need to make a column that starts with A1114 and goes up one A1145,A1146...to A3120 or s

Hello my name is Randy,

I would like to take minute and Thank you for reading my post. I have a spread sheet that contains a column of alphanumeric values. Each next row will go up one numeric value while the letter will stay the same.

A1144
A1145
A1146
A1147
and so. We have about 2000 enteries to make and don't want to make them manually. I used this formula to add the numbers =(SUM(SUBSTITUTE(A1,"a"," ")+0))+1
but can't get the letter to show. I can solve that by using this next formula in the next column ="A"&A2 I just thought there has to be an easier way.

Thanks again. I hope everyone is having a great summer!

Can't you just type in the first two, select both and drag the fill handle (little square in bottom right hand corner of selection) down?

Originally Posted by mrice

Can't you just type in the first two

You don't even need to type 2 of them, only 1 is required for that method to work.