In A1:

="Lan"&TEXT(ROW(),"#00")

Copy down as far as you need

--
Kind regards,

Niek Otten

"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