We have 4,800 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.
Good Day Sir, thanks for this project. I understand your project requirements very much. I can do this perfectly since this is my expertise. Please see PM for further details. Regards, ricworks9
Hello Sir/Madam,
Thank you for place my bid on your project. I am interested to do work with you also having experience team to handle project smoothly.
Thanks,