Help please with generating a number sequence.

  • Thread starter Thread starter Dave T
  • Start date Start date
D

Dave T

Hi , i was wondering , is it possible to generate a number sequence , for
example i have 100 items , i need to have them numbered as focus-00001
through to focus-00100 , is there a command in excel that would allow this ,
also when i add to the list , i would like to be able to say add another 85
items , then i would like to generate focus-00101 through to focus-00185

I presume this will be a equation , but i'm unsure how to do this.
 
Hi Dave

No need for any formulae
Enter focus-00001 in cell A1, grab the fill handle (small black cross
when you hover over the bottom right corner of the cell) and drag down.
Excel will increment the last number for you.
 
If your data starts on row 2, allowing row 1 to contain headers, then
you can put this formula in A2:

="focus-"&TEXT(ROW()-1,"00000")

and copy down the column to row 186.

You can fix these values by highlighting the column, then <copy>, then
Edit | Paste Special | Values (check) | OK then <Esc>.

Hope this helps.

Pete
 
Hi , i was wondering , is it possible to generate a number sequence , for
example i have 100 items , i need to have them numbered as focus-00001
through to focus-00100 , is there a command in excel that would allow this
, also when i add to the list , i would like to be able to say add another
85 items , then i would like to generate focus-00101 through to
focus-00185
Click to expand...

Can you make use of this technique? Place focus-00001 in your starting cell.
Place focus-00002 in the cell underneath your starting cell. Select both
cells and look at the bottom right corner of the selection. Do you see the
small, black square? Place your cursor over it until the cursor turns into a
thin, solid black plus sign (or cross)... click with the left mouse button
and drag down. Let go of the mouse button and see what happens. You can
continue the series by selecting the bottom two cells in the column and
repeating the process outlined above. Simply click/drag down through as many
cells as you need to.

Rick
 
Rick Rothstein (MVP - VB) said:
Can you make use of this technique? Place focus-00001 in your starting
cell. Place focus-00002 in the cell underneath your starting cell. Select
both cells and look at the bottom right corner of the selection. Do you
see the small, black square? Place your cursor over it until the cursor
turns into a thin, solid black plus sign (or cross)... click with the left
mouse button and drag down. Let go of the mouse button and see what
happens. You can continue the series by selecting the bottom two cells in
the column and repeating the process outlined above. Simply click/drag
down through as many cells as you need to.

Rick
Click to expand...
Hi , thank you all for your help , yes the pulling down of the cross does
the trick :)

i do have 1 more rather more complicated question to ask , which i will put
into another subject....
 
Back
Top