I have a CD-ROM that's in notepad form and I need to convert to an excel format.
I have a CD-ROM that's in notepad form Do you mean that you have a notepad file which as been saved to a CD?
What happens when you try to open the file with Excel?
Yes it's a file saved as a CD. When I open to excel the information doesn't line up with the collums. This makes it hard to copy/paste a cell.
Without knowing the setup of your file, I would suggest you look up in the Help files Text to Columns if may be of help.