A solution with a formula only:
We assume that A1=1-3. Fill the following formula into A2 and copy it down.
=IF(A1<>"",IF(ISNUMBER(A1),IF(A1+1<=VALUE(RIGHT(A$1,LEN(A$1)-FIND("-",A$1))),A1+1,""),VALUE(LEFT(A$1,FIND("-",A$1)-1))),"")
The result will be
1
2
3
This works for any numbers devided by -.
1
solved Excel Number Separation [closed]