formula to expand ranges

[rmh000]

I have several entries in a column of data... example:

t334.1 - t356.9
b044 - b059.7
w120.88 - w129.55
1036 - 1048
1044
2233
239
19
12567
H0876

I'd like to know if it's possible to "expand" these "ranges" to include the lines not shown (and represented by) the "-"...

example 2: same list, here's what I'd like to see as final output: (note "etc" denotes omitted lines to shorten post, though I'd like to see ALL lises of detail in the final result)

t334.1
t334.2
t334.3
t334.4
t334.5
t334.6
t334.7
t334.8
t334.9
t335.0
t335.1
(etc)
t356.9
b044.0
b044.1
b044.2
b044.3
b044.4
b044.5
b044.6
b044.7
b044.8
b044.9
b045.0
(etc)
b059.6
b059.7
w120.88
w120.89
w120.90
w120.91
w120.92
(etc)
w129.53
w129.54
w129.55
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1044
2233
239
19
12567
H0876

I can write code for this, but would prefer to have it in Excel, as the folks providing it are not developers... thought it'd be better to empower them with the ability, so they can also see/verify final results...

many thanks...

 

[Jerry Sullivan]

Hi and Welcome to the Board,

If you prefer not to use VBA, then a simple and fairly efficient approach would be to use the AutoFill feature.
Fill data automatically in worksheet cells - Excel - Office.com