Hi,

I've got two rows of data (numbers) I am entering which look like this:

6319890 - 6319896
6319913 - 6319919 etc

Is there another way to 'fill in' the numbers in between rather than typing
the first two then 'dragging' down? It's very time consuming doing it this
way. Thanks

Do you want to insert 6319891 up to 6319895 between the numbers in your first
row and 6319914 to 6319918 in your 2nd row?

If true, and you have 6319891 and 6319914 in col A, then in col B enter
=IF(A1="","",A1+1) Now drag this across as far as you want to go, and down as
far as you need to go. Empty cells will remain empty, and filled cells in
col A will result in incremental numbers in the columns beside it.

If this is not what you are looking for, please be more specific?

"Meredith" wrote:

Hi,

I've got two rows of data (numbers) I am entering which look like this:

6319890 - 6319896
6319913 - 6319919 etc

Is there another way to 'fill in' the numbers in between rather than typing
the first two then 'dragging' down? It's very time consuming doing it this
way. Thanks