Creating a list of years from a set of numbers.

I'm looking for a way to create a consecutive list of numbers in the same row of a set of numbers given in column A.

Here is an example of the data and how I would like it would look like

Data before:
..........Column A - Column B - Column C - Column D - Column E - Column F
Row 1 5-9
Row 2 6-9
Row 3 4-5
Row 4 20-24


Data after
..........Column A - Column B - Column C - Column D - Column E - Column F
Row 1 5-9.............5............6.............7.................8............9
Row 2 6-9.............6............7.............8.................9
Row 3 4-5.............4............5
Row 4 20-24...........20...........21...........22.............. 23...........24

Any help will be great! Thanks

hello look at this one.

create numbers.xlsx

in B1=--TRIM(LEFT($A1,FIND("-",$A1)-1)) -- drag down

in C1 =IF(B1>(--TRIM(RIGHT($A1,FIND("-",$A1)-1)))-1,"",B1+1) drag to the right-->>> then down..
hth.