View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod macropod is offline
external usenet poster
 
Posts: 329
Default 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?