Importing into Excel from Notepad

  • Thread starter Thread starter Steve Sanchez
  • Start date Start date
S

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.
 
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.
 
Back
Top