For more information on Data Analysis tools, please visit The Commons Blog.
What to do if your data is an absolute mess… in Excel
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.