MS Word & Excel.. Please help, its urgent.?

Question

I have information saved on a WORD file but I need to save it in EXCEL so that I can minipulate the work & do sorts. When I copy the info across to EXCEL, all the information only gets copied to the first coulumn instead of seperating it into other columns.

Thanks A Lot

Answer 1

u cant automatically save it in excel and have it formatted that way until u re-do the whole thing and use excel.......

Answer 2

Instead of doing a "cut & paste" save the Word doc somewhere (desktop or whatever) and then go to Excel and click up the top on "DATA" and then "IMPORT". Select the DOC that you just saved and Excel will give you some options on how you want to format the file as it is imported. Some of these option include how to handle columns & rows etc.

Hope this helps.

Answer 3

If the information on Word is in a table format you can do the following:
In Word, Select the table - Copy
In Excel, click the upper-left corner of the worksheet area where you want to paste the table.
Click Paste
*to adjust the format,
click Paste Options- click Match Destination Formatting (to use the formatting in excel) or Keep Source Formatting (to match the formatting of the Word table)

Answer 4

What you can do is to save the doc into a text file with txt extension.

Then when you open the file from Excel, choose that file, check delimiters --> Next --> Tab and Space --> Finish.

You should get them in all column.

Answer 5

if can separate your data at the first colon in excel into colons more than one.
For this purpose use left, right, find, val commands according to your data shape.
Example:
colon 1:
iyi ogrenci

colon 2:
find the position of the blank.

colon 3:
find left part of this

colon 4:
find right part of this.

Answer 6

the information in word file should be comma-separated to be able to view it in excel properly

Answer 7

No clue. Good Luck