Software

Ask something
Discussion Locked

Excel imports

0 helpful
7 replies

by ravenhawk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a user that has data that when imported into Excel places all the information of one row in one row. He wants to break up the information into three columns per row. Attempting to import it as comma deliminated or another other format does not work. Is there a way to divide the information into columns once it is in Excel?

7 replies

by oz_media

A CSV or other taxt delimited file SHOLD have no problem and you're correct in thinking it should work. It may be that during the setup of the CSV import, the fields aern't being MANUALLY mapped correctly. There is a preview when using Import CSV that should help you configure it properly.

Good luck,
OM

by richtee

Excel has a function to convert ?Text to Columns?.

As long as the data has some type of delimiter that defines the individual data sets, you can convert the data in one column into multiple columns.

You can launch the wizard for this function on the menu under ?Data?. First select the entire column, then:

Data | Text to Columns?

then follow the wizard.

Hope this helps, Rich

This discussion is closed to new replies.