Splitting data in a column

[Mike]

I have data in one column that I would like to split into
three columns. Example John Henry Doe is in the name
column. I know would like to have a column for each part
of the name. First Name, Middle name, Last name.

Thanks
Mike

 

[Tim Ferguson]

Example John Henry Doe is in the name
column. I know would like to have a column for each part
of the name. First Name, Middle name, Last name.

1) Easy answer: look up help on Instr() and Left() and Mid() functions.

2) Harder answer: make sure you have a policy for dealing with names like
Madonna, George Harrison Junior, Baron Munchausen and so on.

Best wishes


Tim F