Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making long alphanumeric list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making long alphanumeric list
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making long alphanumeric list
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making long alphanumeric list
Hi
Just type your first value into a cell, then grab the fill handle and pull down the column and it will change the numeric part automatically. The fill handle is the small black cross you see if you hover the cursor over the bottom right corner of the cell. Hold your left mouse button down to garb it, pull the mouse down the page as as far as required then release. If you are going to go into the hundreds, then you might consider starting with Lan001 rather than Lan01. Regards Roger Govier Medtner wrote: 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:) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making long alphanumeric list
Thanks guys ! That's brilliant -- Medtner ------------------------------------------------------------------------ Medtner's Profile: http://www.excelforum.com/member.php...o&userid=29547 View this thread: http://www.excelforum.com/showthread...hreadid=492512 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making words in a list a value!! | Excel Discussion (Misc queries) | |||
Long list of words to find with Filter | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
making one material list from mulitple vendor material lists | Excel Worksheet Functions | |||
making a non-validation list | Excel Worksheet Functions |