Entering data into Excel
I need to enter an enormous lot of lines of data into Excel so I can do some statistical analysis with it. Unfortunately, it has originally been typed onto a Word document and each line has bits of data has each have been seperated by a comma but I need to enter each into an individual cell into excel.
Is there a way to import the data and let excel automatically seperate each bit of data into individual cells and discard the commas?
Thanks in advance
God, grant me the serenity to accept the things I cannot change,
Courage to change the things I can,
And wisdom to know the difference.
Bookmarks