Problem with Importing .csv into Excel

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

I have a csv file with a number of words (probably 1000-2000)
separated by the "|" character. I wanted to import this file into
Excel (Office 2003 Excel), so that I could get each word on a separate
line so I could paste them into a blank text document. The problem is,
when I go to import the .csv file, Excel imports each word into a
column heading, & seeing as how it is limited to 256 columns, my file
is not fully imported. I see that Excel has a 65000 row limit, which
is more then enough, but I cannot see a way to get Excel to import
each word as a separate row, rather than a column. Can anyone help me
out?

Thanks,

CM
 
Open the file in a text editor, and use Edit > Replace to replace each
occurrence of | with a carriage return (newline) character. You don't need
to use Excel for this.
 
Stephen Bye said:
Open the file in a text editor, and use Edit > Replace to replace each
occurrence of | with a carriage return (newline) character. You don't need
to use Excel for this.
Click to expand...

Hi Stephen,

Thanks for that. I will give it a go.

CM
 
Back
Top