Simple autofill question

[EmilyM]

Hello -

I am using Excel 2007, and I am trying to autofill for a column of numbers with a letter, but I can't find a way to do it. For example if I have

62A
63A
64A

I want to be able to use autofill to fill the next cells in with

65A
66A

Etc. But it just repeats the cells that I am dragging down. Does anyone have a workaround for this?

Thanks in advance for your help!

 

[texasalynn]

try this

Excel Workbook
	A
1	62A
2	63A
3	64A
4	65A
5	66A
6	67A
7	68A
8	69A
Sheet1

Excel 2003

Cell Formulas
Range	Formula
A4	=ROW(A65)&"A"
A5	=ROW(A66)&"A"
A6	=ROW(A67)&"A"
A7	=ROW(A68)&"A"
A8	=ROW(A69)&"A"

 

[EmilyM]

Thanks for the quick response!

Thank you! That works great but I don't understand how!

 

[texasalynn]

the row formula returns the number inside the ()

so if you have row(A2) it would return 2

edit:
and by using that formula when you copy it down it increments the Row