Splitting cell data into multiple rows

[Awilkerson10]

I receive a spreadsheet from another individual in which I need 3 columns of data. The spreadsheet is A-L and I use columns B, E, and L.

My data is a little different in that the cell (always column B) may contain a range. The values are seperated by Alt+Enter, the user does not use a delimiter to seperate values. Below is an example of one of the rows of data...
B E L
422433-422448 MM:new #4218350 NC
422453
422457-422472
...so what this means is every item number within the range of 422433-422448, 422453, and 422457-422472 will all tie back to a common code which is found in column E. I have to use =right(trim(E1),7) in order to extract the data from E, and column L is a copy. The data from E and L needs to be repeated for every item in the range of numbers that reside in B. Which would look something like this...
422433 4218350 NC
422434 4218350 NC
422435 4218350 NC
422436 4218350 NC
422437 4218350 NC
etc...
etc...
thru
422472 4218350 NC

Thanks in advance for your help!

 

[Awilkerson10]

B E L
422433-422448 MM:new #4218350 NC
422453
422457-422472

Column E is the text that reads MM:new #4218350
Column L is NC