On Mon, 20 Feb 2006 02:31:34 -0800, "Dawn"
wrote:

Ron

Could you also let me know the formula to use to so I can extract the
christian name from the column.

Many thanks

Dawn

Try this:

=LEFT(A1,FIND(CHAR(1),SUBSTITUTE(
A1," ",CHAR(1),LEN(A1)-LEN(
SUBSTITUTE(A1," ",""))))-1)


--ron