I'm using office 2007.
I have a list of 500ish addresses that someone typed up in word. They need each address to be on its own row in Excel.
This would be relatively simple if the addresses were all the same number of lines long; however, they are not.
Some are 3 lines. Some are 4. Some are 5, 6, even 7 lines long. All of the different length addresses are scattered randomly throughout the document.
Is there an easy way that I am missing to convert this giant list into an Excel document?
I would prefer not to have to separate the different length files into different documents and use "convert text to table" from there.