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 SpecialValues
Delete columns A&B

--
Regards

Roger Govier


"Louise" wrote in message
...
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 a-

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