How to seperate into firstname, secondname etc...

[mzainims]

I've got this nagging situation/s.

In my excel files I've this:

examples in the tables are as below:

Names	FirstName	MiddleName	LastName
Roberto Engelesias Darwin
Subramurthy s/o Thirumurthy
Abdool Kassim ibnu Murshid
Azmi Bin Abdullah

How do I seperate it into e.g. Roberto Engelesias Darwin into FirstName==Roberto Englesias, LastName==Darwin (note there is no Middlename)
..and Subramurthy s/o Thirumurthy into Firstname==Subramurthy, Middle==s/o, LastName==Thirumurthy

I've tried the LEFT(C4,6) but this will only takes "Robert" if I modified it with LEFT(C4,17), it will take "Robert Engelesias".....but what about another 6000 rows?
There will be about 6000 to 8000 rows of this names in the excel files.

Any ideas?

 

[Chaddyb]

Not Sure how excel can do this if there is no common logic.
If you cant expect a human to know where to put the different names you cannot expect a formula to do this

 

[mzainims]

Not Sure how excel can do this if there is no common logic.
If you cant expect a human to know where to put the different names you cannot expect a formula to do this

Yes bro.... you're right on this... but the matter is, all the top bosses needed it in excel format and the guy "down" there fulfills the task. Me on the other hand have to "separate" all this data....hope there's somebody out here got some light to this.
Cheers bro.