Importing into Excel from Notepad

[Steve Sanchez]

I have datafiles in text format (Notepad) that have one
field per row and a pipe delimeter (|) after each record.
I want to import this data into Excel but it doesn't
recognize a carriage return as a delimiter.

How can I import this data into Excel so each line is a
different field and a new record is begun after the pipe
delimeter?

Thank you for the help.

 

[Guest]

hi,
i assume that you are using text to columns function.
when the wizard comes up, in the other box for delimiter
enter |. the wizard will then recognize the pipe delimeter.