Creating a list of numbers in sequence

[Louise]

Hi all

I am entering some voucher numbers into a cell and wish to copy it down to
autocomplete the rest, however, I can't seem to get it to work. The numbers
I have entered are:-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so on but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise

 

[Roger Govier]

Hi Louise

One way
Assuming your exiting data starts in A1, insert 2 columns in front of
your existing column
In A1 enter 100, in B1 enter 199
In A2 enter = A1+100, in B2 enter = B1+100
Copy both down as far as required.
In cell C1 enter
=A1&" - "&B1
Copy down
Copy whole of column C and Paste Special>Values
Delete columns A&B

 

[Louise]

That worked a treat! Thank you.

Louise

Hi Louise

One way
Assuming your exiting data starts in A1, insert 2 columns in front of
your existing column
In A1 enter 100, in B1 enter 199
In A2 enter = A1+100, in B2 enter = B1+100
Copy both down as far as required.
In cell C1 enter
=A1&" - "&B1
Copy down
Copy whole of column C and Paste Special>Values
Delete columns A&B

 

[Leo Heuser]

Hi all

I am entering some voucher numbers into a cell and wish to copy it down to
autocomplete the rest, however, I can't seem to get it to work. The
numbers
I have entered are:-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so on
but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise

Hi Louise

Another option:

In A1:

=ROW()*100&"-"&ROW()*100+99

Copy A1 down with the fill handle (the little square in
the lower right corner of the cell).

 

[Nobody]

Try this:
=LEFT(A2,FIND("-",A2)-1)+100&"-"&RIGHT(A2,LEN(A2)-FIND("-",A2))+100
copy all the way down