Just enter Lan01 in the first cell,, then move the cursor to the
bottom-right corner of the cell until it changes to a black cross, then drag
and copy as far as you want.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Medtner" wrote in
message ...

Sorry guys this is a newbie question I know...

But how do you make a long alphanumeric list in excel automatically
without having to type all the figures etc...

eg Lan01
Lan02

..
...


Lan101 etc.

Thanks:)


--
Medtner
------------------------------------------------------------------------
Medtner's Profile:
http://www.excelforum.com/member.php...o&userid=29547
View this thread: http://www.excelforum.com/showthread...hreadid=492512