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?