
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
By default Excel will do that, just type Dog1 in the first cell and then copy down and the numbers will increment -- Regards, Peo Sjoblom "Zaphod Beeblebrox" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does anyone know how to get Excel to label cells in a column so that > it repeats a word but adds ascending numbers to the word in each cell? > (i.e. I want column A to read Dog1, Dog2, Dog3...Dog160 without > having to type "Dog" and the numbers for each individual cell). > Thanks! > Zaphod Beeblebrox
| <-- __Chronological__ --> | <-- __Thread__ --> |