Try

=LEFT(A1,FIND(" ",A1))

This should give you the characters up until the first space. If the are
seperated by a comma then substitute the " " with ","

Cheers,

Mike



"Keith" wrote:

I have a column cintaining addresses. What I want to do is, in the next
column have just the first word from the address cell.

Is there a way to do this other than copy and past? I have about 3000 rowns
to do?