| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
![Jim Cone[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
