One way, assuming the names are all in a "2 word" structu

In B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)

In C1: =MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,99)
("99" is arbitrary, just choose a number high enough
to extract the max likely # of characters in the 2nd word)

Another easier? way to try is to use: Data Text to columns

Select A1
Click Data Text to columns Next
In step2 of the wizard, check the box for "Space"
Click Finish
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Martyn" wrote in message
...
Hi,
I need the formula for splitting names...
i.e need "Martyn Williams" in A1 to be splitted to "Martyn" and "Williams"
in B1 and C1
TIA