I'm trying to distribute data that exists in one cell to separate cells. The given data exists in column A and I imagine that columns B,C,D,E etc will each need formulas to grab the pertinent data (first name, middle name, last name, class, grade %) . I'm using Excel for Mac and can't use macros. Any help would be amazing

(I've attached a sample worksheet and a pic)

TEST TEMPLATE.xls
Screen Shot 2014-04-14 at 3.22.19 PM.png