Katie L. (job poster) hired Helena .. (Tasker) to help with this task. Got a similar task you need done?

Separate out data in excel files

Posted by Katie L.



Due date
Wednesday, 10th Apr 2013
I have four excel worksheets that I want to import into my Mac contacts, but the columns contain more than one piece of information. For example, the telephone column has 'M: [admin: private contact details hidden (Airtasker trust and safety policy). Private messaging feature available once task assigned]W: [Content Moderated] I just want them in their own fields and stripped of any non essential data that isn't needed when I do the import.
Helena ..
100%Completion rate

The percentage of accepted tasks this Tasker has completed.

Task Activity
9 comments about this Task
Comments are now closed
Hi Katie. If the only problem is with the phone numbers in one cell as shown in the example, exporting the numbers individually is extremely easy - e.g. you just replace all the "m:"''s and "w:"'s with semi-colons and use text-to-columns function (setting ";" as the delimiter). You can them TRIM the data to get rid of outer spaces. Do you need anything else split up? I'm free the next 2 hours if you need immediate help.
Hi Katie ,

I have data entry experience in excel and I would be happy to help in this
Hi do you still need some help?
I'd be more than happy to do this for you Katie. :-)
Task Assigned
0 new tasks