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!