Converting .csv file to .xls file

**Avidean** · 10-06-2011, 08:22 AM

Hi,

Sorry for my ignorance! I have a .csv database file with 5 or 6 different data types under heading. I can open it with Excel but the heading and the data are not serparated in proper excel columbs but merely seperated by a vertical line between each heading and each value.
The data is in rows under the headings which are in row number 1. The file has about 60,000 rows of data.

Is there a way the I can get excel to seperate the Data in proper columbs?

Thanks,
Dave

**arthurbr** · 10-06-2011, 08:31 AM

Have you tried Data - Text to columns using the vertical line you mention as separator?

**Avidean** · 10-06-2011, 10:54 AM

Originally Posted by arthurbr

Have you tried Data - Text to columns using the vertical line you mention as separator?

Could you give me a quick explanation of how to do that?

Thanks,

Dave

**Avidean** · 10-06-2011, 11:05 AM

Originally Posted by arthurbr

Have you tried Data - Text to columns using the vertical line you mention as separator?

Thats great just figured it out for myself thanks

**Avidean** · 10-06-2011, 01:23 PM

now for my next hurdle. I need to take one columb of data and put it in a single cell with each value separated by a comma. I then want to copy and paste the content of that cell into a word doc. Can this be done?