Excel guru to reformat data

=> Summary We have 2 spreadsheets that has data all in one column. We need that data reformatted into separate cells. => Details Here is an example of one cell: Accounting;Bookkeeping;Consulting;Setup & Conversion;Training;Level 13, 40 Creek Street BRISBANE QLD 4000 We want to ignore the first "Categories" and only split the address data into the following format Street, city, state, postcode - so the result of the above line would be: Level 13, 40 Creek Street | BRISBANE | QLD | 4000 Please not the data is NOT formatted the same way in every cell. for example some cells have the following formatting: Accounting , Bookkeeping , Consulting , Setup & Conversion , Training Level 1, 68 Alfred South Street MILSONS POINT NSW 2061 and others: Accounting;Bookkeeping;Consulting;Setup & Conversion;Suite 5 255 Whitehorse Rd;BALWYN VIC 3103 There approximately 573 rows in one spreadsheet and 315 rows in the second. I would suggest this work is done using a series of formulas (not manually) if done using formulas I require that you provide the sheet WITH the formulas as we will need to transfer the formula into our full data sheet (we can not provide the full data sheet due to privacy laws) => How to bid To bid on the project start your reply with the words "Excel guru" to show you have fully read and understood the requirements of this project.