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"
wrote in message
news:Push.Latency.1xiiuf_1130335542.8711@excelforu m-nospam.com...

Greetings.

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