How to make data range from 1 to 17 million in 400 excel column?

[matahazel28]

Dear all
I would like to make range data like this,
1-100
100-199
200- .....

it is just an example. However, I would like to make data range from 1-17.000.000 in 400 column.
It will be difficult if I make it manually. I would like to make it using Excel.
Does anyone know how to make that?
I appreciate your help!
Thank you.

 

[Joe4]

Is this what you are looking for?
Place this formula in row 1 and copy down:

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

Note the duplication of 100 you had in your example:
1-100
100-199

I assuming that the second one should really be 101-200.

 

[Eric W]

Or do you mean something like this:

A1:

=SEQUENCE(42500,400)

 

[matahazel28]

Is this what you are looking for?
Place this formula in row 1 and copy down:

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

Note the duplication of 100 you had in your example:
1-100
100-199

I assuming that the second one should really be 101-200.

Yes, that is the solution. Thank you

 

[Joe4]

You are welcome.
Glad we were able to help!