A simple listing desire...

P

Push Latency

Greetings.

I am compiling an archive of the recorded lectures at a university.
am trying to have Excel automatically add a specifically formatte
reference number in its own column along with each entry on each row
(something like "E001L... E002L...E003L, etc.).

I imagine that this is an extremely simple function, but it seems tha
it the simplest of things is also often the most elusive. I think thi
has something to do with either dynamic ranges or arrays...

Thank you, in advance, for any help anyone can offer
 
M

Mladen_Dj

Use formula:

="E"&TEXT(ROW(),"000")&"L"

If your listing dont start in row 1, simply subtract number of previous rows
from your first row(). For example if you start in row 3, use ...ROW()-2...
in your formula, and resize formula to the end of lectures list.


"Push Latency" <[email protected]>
wrote in message
news:p[email protected]...
 
P

Push Latency

Thank you! However, i am still doing something wrong.

The formula you provided seems to only fill-in the first cell in th
list, but i need it to fill-in all the way to E001L - E700L or so, an
to automatically fit new entries into place.

Any idea what i am doing wrong?

Thanks again for your help, and in advance for any furthe
assistance..
 
M

Mladen_Dj

Simply, select cell where is formula, move cursor to tiny black sqare in the
right-down border of cell (your cursor will change to black cross), duble
click it (or just drag it), and your formula will be pasted to the end of
list...

"Push Latency" <[email protected]>
wrote in message
news:p[email protected]...
 
J

JMB

You could also use a custom number format.

Click Format/Cells, select custom and in the text box enter

"E"000"L"

When you enter number 1, should appear as

E001L

Note that this will affect only how the number is displayed on the screen,
excel will still store the values as numbers (which is important if you plan
to use this data as arguments in other formulas - but you could always use
the TEXT function to do the necessary conversion).
 
Top