I have a text column that i need to split into several columns, i need to know how to go about doing this in excel. I have tried using MS query with the following code:

UPDATE `'export #3596765$'` SET name = Trim(Mid$([msgtext],InStrRev([msgtext]," ")))
WHERE InStrRev([msgtext]," ")>0;

when i run this is get the error 'Undefined function InStrRev in expression'

the data i need to split is;

msgtext
Second Driver Start Mark Job1

to

msgtext Name Job
Second Driver Start Mark Job1

Thanks in advance