I am using Quickbooks Premium 2008 as the accounting software. I do many
exports into excel. For this example I export the profit and loss statement
to excel in order to do analysis work.

When the statement is export the text and data are not all left justified.
Ex:

Row 1 Operating expenses:
Row 2 Personnel
Row 3 Salaried
Row 4 Hourly
Row 5 Commissions
Row 6 Total
Row 7 Auto expense
Row 8 Bank charges

This is a very short example. The amounts for each account are in another
column.
Anyway I want to be able to have all the text in the same column and not
spread over 3-5 columns.

What is the best way to accomplish that?

Thank you for your help

Pat

--
Pat

=A1&B1&C1

Or maybe you want spaces in the
=A1&" "&B1&" "&C1