Edit Address Fields in Excel Spreadsheet

I have a Worksheet with 140 records, one of the columns is Address and contains the full address of a business.
I want this column re-entering under numerous columns (Address 1, Address 2, Address 3, Address 4, Post Code)
This should only take an hour or two at most.
This is only one of many worksheets I have so although you would only be doing this one worksheet now, the successful applicant would be offered more as there will be around 15-20 worksheets in total.