autofill with number embedded in text

B

beckstei

I have the following pattern:
student1c
student2c
student3c

I want to autofill columns with the number incrementing.

Can you tell me how to do this?

Thanks very much
 
G

Guest

Hi
You could use the COLUMN() function which will stick in the column number:
="student"&COLUMN()&"c"
Similarly, you could use COLUMN()-2, or COLUMN()+3 or whatever you need to
get the right number in there!

Hope this helps.
Andy.
 
Top