Why does Excel not take text from the clipboard?
Excel should be able to copy and paste similarly to any other Office applications, however, if you are pasting from another application, it all may paste into one cell. Without knowing some more specifics, your problem is difficult to diagnose.
Here is an excellent website that walks through the process in Excel: http://www.excelfunctions.net/Excel-Copy-Paste.html