Hi KHTheany,

Welcome back. I can see this is an important task for you, and, like my colleague, I'm with you on how separating those columns in QuickBooks Desktop before exporting would be easier. I can clarify what Rebecca mentioned above.

QuickBooks Desktop has certain ways that it organizes information in reports. In this case, the item number is included in the same column as the description, and the two cannot be separated in the report itself. Because of that, it'll mean manual work on your end once you get the file into Excel.

What you can consider, if you haven't already done so, is including the Item Description column in your Sales by Customer Detail report. This won't separate the item number and description from one another, but it does add an additional column where the item description is by itself. In doing that, all you would have to do once the file is in Excel is remove the additional description information from the item number column. To add the Item Description column, select Customize Report, then use the Columns section on the Display tab to add the Item Description column. Click OK when you're ready to run the report again.

I know this can cause extra work, especially if the report has a lot of data, however there isn't another way to handle this at this time. This is why the Feedback option is such a valuable asset. Our product development team loves hearing from users about how certain features are impacting them and what might be done to make things even easier. Don't hesitate to share your thoughts using the feedback option via the Help menu.

I hope that helps clear things up, but don't hesitate if you have further questions.