Copying and Pasting help please

[david93436]

I have a document in Wordpad that has 20 lines and 10 columns. I want to copy this in excel to make sorting and editing easier.

I tried simply copying and pasting but ended up with the entire document in one cell.

I tried selecting 20 lines and 10 columns and then copying and pasting but ended up with all 20 lines but the 10 columns were all in the same cell.

I wanted each line (20 lines) on a seperate cell line AND each column (10 columns) in a seperate cell column.

Can anyone advise please?

 

[pgc01]

I tried selecting 20 lines and 10 columns and then copying and pasting but ended up with all 20 lines but the 10 columns were all in the same cell.

Hi David
Welcome to the board

Try selecting the cells and use Data->Text to Columns to split the text in the cells. Try Tab for the delimiter.