How to import notpad data into excel

I transferred a file from a database that will only save reports in Notepad.
I then, cut and paste the data into Excel. However all of the info is merged
into one cell. How can I format this data, so that it will be a simple
worksheet with more than one cell? i.e. Name, SSN, Home address should all be in different cells

Do i require any software or is there any technique or tool which can help me to import  into excel....