MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text delimited files


Posted by Pat on January 16, 2002 5:26 AM

How can I take a text delimited file that lists data in rows and convert some of that data to a column spreadsheet? Can you help me?


Posted by thomas venn on January 16, 2002 10:41 AM


how about doing the text to columns (parse), then copy and paste specials as transpose.

cheers,

- thomas