Excel users

I've been wondering this for a long time as all of my spreadsheet work to date has been painstakingly written cell by cell even with the information I'm attempting to place in front of me because I can't copy and paste multiple lines of text into more than one cell. Google has failed me; for some reason it's full of questions asking how to do exactly what I don't want which is somewhat baffling because I can't get away from it.

Basically I want to be able to take something like this

Line 1
Line 2
Line 3

and to copy it all at one time and have it go into

[Cell 1]
[Cell 2]
[Cell 3]

instead of just going

[Line 1
Line 2
Line 3]
[Cell 2]
[Cell 3]

I hope that's clear.

You mean copying a whole column from excel and pasting it while selecting only the top cell of destination?

Or if it is from outside excell and you want it to come in different lines in excel? I have a few methods that work but it's generally harder then, involves general editting on microsoft word before throwing it in excel.

For example I was able to copy the KMS-BB skill tables directly into excel all at once or the EXP chart that's found on hidden-street.

Highlight/select 3 vertical cells, pasta, profit.

Highlight/select 3 vertical cells, pasta, profit.

This worked perfectly, thanks. It auto-adjusted and filled the rest of the 900 lines. Still a ton of work to be done like finding and replacing irrelevant information but that should take less time than typing out 900 cells at approximately 10 words per cell.

Shidoshi: Yes, I wanted to copy it from an outside source.

For finding irrelevant information to delete it's normally easier to do it with Word's Search and Substitute. Be sure to look at the list of special characters you can substitute (new lines, tabulations, etc)