Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
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!!!