| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excell
need help incrementing a row of inventory numbers (that are preceded by a
letter) formula to increment U0750 to U0751..to U0850. also another column of alias for same unit AWWU U0750 to AWWU U0751..to AWWU U0850. seems like I did this once in past but have slept since then, thanks for any help provided |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excell
Simply enter , say, U0750, into a cell. Then grab the fill handle (the
little square dot at the bottom right corner of the cell) and drag it as far as you want. The number part will increment. HTH Otto "dam" wrote in message ... need help incrementing a row of inventory numbers (that are preceded by a letter) formula to increment U0750 to U0751..to U0850. also another column of alias for same unit AWWU U0750 to AWWU U0751..to AWWU U0850. seems like I did this once in past but have slept since then, thanks for any help provided |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excell
Enter U0750 in a cell.
Right-click and drag down......release button and select "Fill Series" Same for AWWU U0750 Gord Dibben MS Excel MVP On Mon, 5 Oct 2009 14:11:02 -0700, dam wrote: need help incrementing a row of inventory numbers (that are preceded by a letter) formula to increment U0750 to U0751..to U0850. also another column of alias for same unit AWWU U0750 to AWWU U0751..to AWWU U0850. seems like I did this once in past but have slept since then, thanks for any help provided |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excell
wow..now i really feel like a big dummy. I have spent a bit of time trying
to solve this. thanks for the help. dam "Otto Moehrbach" wrote: Simply enter , say, U0750, into a cell. Then grab the fill handle (the little square dot at the bottom right corner of the cell) and drag it as far as you want. The number part will increment. HTH Otto "dam" wrote in message ... need help incrementing a row of inventory numbers (that are preceded by a letter) formula to increment U0750 to U0751..to U0850. also another column of alias for same unit AWWU U0750 to AWWU U0751..to AWWU U0850. seems like I did this once in past but have slept since then, thanks for any help provided |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excell
Welcome to the club. Thanks for the feedback. Otto
"dam" wrote in message ... wow..now i really feel like a big dummy. I have spent a bit of time trying to solve this. thanks for the help. dam "Otto Moehrbach" wrote: Simply enter , say, U0750, into a cell. Then grab the fill handle (the little square dot at the bottom right corner of the cell) and drag it as far as you want. The number part will increment. HTH Otto "dam" wrote in message ... need help incrementing a row of inventory numbers (that are preceded by a letter) formula to increment U0750 to U0751..to U0850. also another column of alias for same unit AWWU U0750 to AWWU U0751..to AWWU U0850. seems like I did this once in past but have slept since then, thanks for any help provided |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the normal excell icon on an excell file? | Excel Worksheet Functions | |||
| auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Linear Mode
