autofill with number embedded in text

[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
B

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>