Importing TXT with multiple delineators

  • Thread starter Thread starter Capt Phil
  • Start date Start date
C

Capt Phil

I'm trying to import a .txt file to excel, but produce only two columns
per row. I can differentiate between my row delineator and my column
delineator, but don't know how to import the .txt without it all going
into one row...

Any ideas?
 
Just do a normal import with the first delimitor, then do a text t
columns (from the Data menu) with the second delimitor. You may nee
to insert some columns so the data doesn't get written over...
 
OK, so when I import, it runs my data only in row 1, for miles and miles
horizontally....


When I ask it to 'text to columns', it says it can only do that with
one column at a time... but I have thousands???


Sorry... newbie!:confused:
 
Not sure if I understand, but if the problem is that Excel does not recognize
the row delimiter, you can open the text file in a word processor and replace
the row delimiters with ordinary return characters. In MS Word, for example, use
"^p" (without the quotes). Then import into Excel.

HTH
Anders Silven
 
Back
Top