Starting my week off with another challenge, I'm planning on just chugging through them all in order to learn something new from each one, still very much a newbie !
First, im use text to column tool to obtain the 3 fields, using a ',' delimiter. Then, im cleasing the punctuations in all fields, this isnt a problem with the date field because datetime tool is possible to custom a date format (ddMon.yy in this excercise); finally only select the fields. Good luck!!!