Quickbooks exports to Excel, cleaning up the mess afterwards

[Mick Warren, TechniCater]

Quickbooks 2005~06 compiles ypur Customer:jobs list with the jobs related to
the customer below & indented to the right, eg;
John Smith
Kleenmaid washing machine
Maytag clothes dryer
After exporting to Excel you get a single column which looks like this;
John Smith
John Smith:Kleenmaid washing machine
John Smith:Maytag clothes dryer
I need to end up with 2 columns which reflect the parent / child status, eg;
John Smith (next column)
Kleenmaid washing machine
Maytag clothes dryer
Manually seperating them is not an option, approx 1400 entries & counting.
It's part of a project which allows field service techs to use data from
Quickbooks on their PDA's for on-site job reporting.
I have a basic knowledge of both programs, can someone please tell me a way
to acheive this seemingly simple task? Mick

 

[wjohnson]

In Excel - Select the column and then Select DATA - TEXT TO COLUMNS and
follow the instruction on the pop-up menu.