Word / Excel Help

Hello all

Im at work and someone has given me some bad data.

Its on word and looks like the fllowing

Ms a Sample
1 Sample Lane
Sample Town
Sample County
ME34 LALA
E-Mail: Sample@aol.com

Ms a Sample
1 Sample house
Sample Lane
Sample Town
Sample County
ME34 LALA

E-Mail: Sample@aol.com



I have 366 odd addresses where there the address lines range from 4 lines to 6 lines, gaps in data etc.

I need to get this into excell into a table with

name | Address line 1 | address line 2 | address line 3 | ETC

I have tried putting it inot excell deleting blanks then pasting into word, then doing Text to table convert but because the address lines are not spaced the fields come out in the incorrect collums rows etc Ideas>???? Thanks JL