Addresses In One Cell

In this scenario, we have received the data from an outside source and the Address Lines, City, State and Zip are all in one cell.  QuickBooks does not have an easy way to get this information into the database so we will cover some Excel functions to get the data into the format needed for importing or pasting.