Combine text and cells

[Guest]

I have imported a report from an accounting program using Import External
Data. When setting up the columns, it messes up the alignment of the titles
at the top and number totals at the bottom. When I select the cells to merge
them it will only keep the info in the far left cell. Any easy fixes?

Example: A B C
Accou ting Repo rt

 

[Guest]

In column D type

=A1&B1&C1

 

[Gord Dibben]

Jen

You should be able to format the way the data is parsed before you bring it into
Excel.

When you go to Data>Import External Data what are your next steps?

Database query or Web query?

There should be an Options button where you can set up the import format.


Gord Dibben MS Excel MVP