Realign data within a Excel spreadsheet.

I have an Excell spreadsheet with 1762 contact entered into it. The address are entered into one field and I need these splitting into 5 separate fields Add1, Add,2 Town, County, Postcode. I have been using the 'Data - Text to Columns' feature within Excel to convert these but have found the addresses are not al the same format so you can't do this globally but need to work through each one individually or a batch together. I have complete 285 entries but need the remaining 1477 sorting out.