Quote:
Originally Posted by Julz24
Quick Update:
I copied and pasted the list into Excel for Mac. Now I just need to organize all of the information. It transfered over into one row unfortunately.
|
The problem with copy/pasting directly from your browser into the spreadsheet is that the formatting data may also have been copied (this is how it works with Excel on Windows, at least).
Two things two try rather than manually breaking that data into rows:
a.) Copy and paste it into a basic text editor and THEN copy it again and paste it into your program. In the Windows world, I'd use Notepad and then Excel. This will cause any formatting data that may have also been copied to be lost and *should* respect the proper rows/columns.
b.) If (a) above doesn't work, then again use the text editor but this time save the file and import (as opposed to open) it into your program. It *should* allow you to specify the where each column starts and ends, and should recognize each individual row.
Good luck!
Richard.