Removing info from a cell

[flyingmonkeyofdoom]

I have a cell that contains a persons forename and surname

What i require is to split out the forename and surname

Is this possible?
and if so how would i go about it (baring manually doing it that is)

 

[VoG]

You can use Data > Text To Columns, specify Delimited with Space as the delimiter.

 

[flyingmonkeyofdoom]

thanks that works great