Use the “Text to Columns” function! Let’s say this is your data:
Select the data you want to use…
Select “Delimited” for the file type. Click “Next”
Select the proper delimiters for your data. For mine, I had Commas and Spaces. Click Next for more formatting options or click Finish.
Yay.The data looks wonderful. *Please note, your data might not be perfect after you are done and you might have to use the “Text to Columns” function several times.
For more information on Data Analysis tools, please visit The Commons Blog.