Can Excel "Autonumber" using the Alphabet?
Hi,
I don't think you can do that with autofill. However, here's a formula to do it for you:
=IF(INT((ROW()-1)/26)=0,"",CHAR(64 + INT((ROW() -1)/ 26))) & CHAR(64 + MOD(ROW()-1,26)+1)
Simply put it in row 1 & copy down as far as needed. It'll cope with up to 702 rows (ie to 'ZZ').
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"jgraves" wrote in message ...
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?
|