Splitting Columns

[m.akki]

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

[sweep]

Hi,

use the text to columns option in the data menu, and select space as the delimiter.

[davesexcel]

Try running text to columns

data=>text to columns