how do i split first and last name without splitting my skull
I have a numbers file imported from .xls, open in Numbers 09, and before I spring for going back to MS Office, I was hoping to figure out how to easily split a single column that has first and last name in it.
The numbers file has headers for "full name" and then I added two columns next to it "first name" and "last name" but that's where the fun ends.
I've googled, even bought "the missing manual O'reilly e-book", and I'm still not getting this right. I have seen lots of formulas and such, but not one works for me. I'm definitely doing something wrong and I'm hoping I can find someone who can give me an easy to understand answer as to where the formula needs to go, how to apply it to the WHOLE column of data and not have to do one by one, etc etc. Seem to be finding lots of formulas with no assumption that someone may not know where to put the actual string, etc.
Thanks!