Excel 2003 -??
Another (weird?) way...
Enter this formula in every cell in row 1...
=ADDRESS(ROW(),COLUMN(),4)
Enter this formula in any cell in row 5 and fill down...
=12345&LEFT(OFFSET($A$1,0,ROW()-5,1,1),(ROW()-310)+1)
It is good for 256 entries: 12345A thru 12345IV
--
Jim Cone
Portland, Oregon USA
"MJ"
wrote in message
I am trying to use the Auto-Numbering feature but with alphabets:
what I need; to auto add the alphabet when i drag scroll down so it should
look like this:
12345A
12345B
12345C
Currently i just keep getting a copy of the first cell
12345A
12345A etc,.
any suggestions or ideas if that is possible in excel 2003
|