Splitting a Cell cintent
 

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?

Splitting a Cell cintent
 

Go to Data--Text to Columns and select space as your delimeter.

This will create columns out of your addresses--one column for every space
in the address field. Since you only want the first word, copy that first
column and use it as you wish. Delete the rest.

One note: if you have data to the right of the column that contains
addresses, make sure to insert several blank columns between the address
column and that data BEFORE you do the text to columns operation, else, your
data will be replaced with the split addresses.

Dave
--
Brevity is the soul of wit.


"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?

Splitting a Cell cintent
 

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?