Data entry - excel, urgent

We have approx 4,000 rows of data in our excel spreadsheet and there is one column that needs to have the data separated in to 4 different columns. It is too random to create rules that automate the process, but "Fixed Width" text to column techniques could be used to separate the first two columns. An example cell we need to split is as follow: Signs & Symbols - line artA New Guinea [login to view URL] Wallaby belongs to the Kangaroo family of [login to view URL] Guinea is part of the Malay Archipelago off the North coast of [login to view URL], marsupial, AustraliaSE In this example, the new cells would contain the information like this: Signs & Symbols line art A New Guinea wallaby. The Wallaby belongs to the Kangaroo family of [login to view URL] Guinea is part of the Malay Archipelago off the North coast of Australia. animal, marsupial, AustraliaSE The first two are categories, then the title, then the description, then the keywords. Please only bid on this if you have a small team who can start today as we need it asap.