formula to expand ranges

rmh000

New Member
Joined
Dec 5, 2012
Messages
1
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...
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,117
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top