I've got one column that has names in it...
Joe Smith
Wilbur Jones
Hank Williams
etc...
I want to separate the FirstName and LastName into columns.

I'll copy the data to other columns, then...
How do I remove all characters AFTER the first Space (= FirstName)?
How do I remove all characters UP TO and including the first Space (=
LastName)?

I understand that won't work for all names, like...
T S Elliott
but it will work for most.

Thanks in advance, people.

Mark246