Copy data from one column and create a new one

For 'Course Cde'

=LEFT(A2,FIND(" ",A2)-1)

For 'Couse Sec'

=RIGHT(A2,LEN(A2)-FIND(" ",A2,1+FIND(" ",A2)))

THAT IS ASSUMING the data you are splitting is in the A column - you would put that formula in row 2 and copy down. This also assumes you will ALWAYS have 'Course Cde'(space)'number'(space)'course sec' in your data column (it's breaking up the string based on where the spaces occur).