And one more..........

=SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")

Copied down to A256


Gord Dibben MS Excel MVP

On 20 Mar 2007 18:31:22 -0700, "Mladen_Dj" wrote:

On Mar 21, 2:08 am, jgraves wrote:
I am using Excel 2003 on Windows XP Professional.
I have a spreadsheet that has a vertical list of values.
I would like to place the letter "A" in the cell immediately to the left of
the first value, then fill the cell below that with "B" and so forth all the
way down to "DA".
I know how to do this with numbers, but can this be done with letters?

Not out of box, but you can create custom list. First you must enter
all list elements in cells, than select range with list and go to
Tools- Options - Custom lists. Select range with your list, and next
time you can use this list as autonumber feature.

Alternative way, you can use ADDRESS function which produce cell
reference as text, and extract alphabetic part, which is column header
actually:

=LEFT(ADDRESS(1;ROW();4);FIND(1;ADDRESS(1;ROW();4 ))-1)