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.
Hi. I would like to offer you my services for your formatting task. I am an individual, but know exactly how to deal with the issue you have and can return to you a corrected file within 2 days at most...maybe within 1 after I see the file. If you want me to start, I can start now and give you an even quicker turn around..by tomorrow. Here's to hoping you will take a chance on a newbie!