Splitting data in a column

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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.
Click to expand...

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
 
Back
Top