Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quickbooks exports to Excel, cleaning up the mess afterwards
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quickbooks exports to Excel, cleaning up the mess afterwards
In Excel - Select the column and then Select DATA - TEXT TO COLUMNS and follow the instruction on the pop-up menu. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=535988 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable automatic refresh | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Excel to QuickBooks Accountant Premier 2005 | Excel Discussion (Misc queries) |