Importing txt into Excel?

Question

I have some large txt file I need to import into an Excel spreadsheet. When I import the txt file my data is displayed as rows. How do I convert the rows into columns and get Excel to import the multiple pages into each specific column?

Answer 1

Data that is arranged in rows can be converted into columns by clicking the "Transpose" check box when performing Edit>>Paste Special.

For example, say you have data in row 1 columns A thru D.

- Highlight the four cells and click Edit>>Copy (or CTRL-C).
- Click on the cell E3
- Right click and select Paste Special
- Click on the Transpose box at the lower right
- Click OK and the data will be in cells E3, E4, E5 and E6

Incidentally, the same works for converting columns to rows. However, more to the point of your question, while using Transpose to convert rows to columns or columns to rows, this will operate on one row or column at a time. To do so repetitively to reformat an entire sheet of data would require a macro (or VBA coding).

Good luck!
EC

Answer 2

just paste it into a spreadsheet and then...

click on Data / Text to Columns

that will give you some choices for making the data into columns.

Answer 3

File->Import

Select comma delimited (CSV) or space delimited

Answer 4

copy-paste