Fill

S

Shan

I know to create 1, 2, 3, 4, etc., down 1 column, I would use the fill handle
and drag down or to the side to continually number. However, the numbering I
need to create is 1L, 2L, 3L, 4L, etc., down in 1 column. Is there a way to
do this easily in Excel? I am sure it is very simple and I just can't seem to
figure it out.

Thanks!
 
E

Earl Kiosterud

Shan,

I don't think the Fill Handle, nor paste special will do what you want. If
you can use L1, L2... instead, the Fill Handle will do it.

You could put only the 1, 2, 3, etc. in the cell (which the Fill Handle will
facilitate), and format (Format - Cells - Number - Custom) as

General"L"

Any formulas with reference to the cells will get the number only, without
the L.
--------------------------------------
You could use =ROW() & "L" This works only starting in row 1.
---------------------------------------
If L1 will be in a row other than row 1, you could put 1L in the first, then
in the next cell down, use:

=ROW() -ROW(A2) + 1 & "L"

This is for the first one being in A2. Change the reference to A2 as
needed. The formula above would go in A3. Copy down. You won't be able to
move these around, or sort the table, or delete or insert rows, as everthing
will get renumbered consecutively. To make them permanent (so each will be
a hard value, and can be sorted, deleted, moved, etc), you could copy all
these cells, then Paste Special - Values. now you'llhave a hard 1L, 2L...
in each cell, as if you'd typed them.
 
Top