autofill with number embedded in text
 

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
B


--
beckstei
------------------------------------------------------------------------
beckstei's Profile: http://www.excelforum.com/member.php...o&userid=34802
View this thread: http://www.excelforum.com/showthread...hreadid=545560

autofill with number embedded in text
 

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.

"beckstei" wrote in
message ...

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
B


--
beckstei
------------------------------------------------------------------------
beckstei's Profile:
http://www.excelforum.com/member.php...o&userid=34802
View this thread: http://www.excelforum.com/showthread...hreadid=545560