Splitting a Cell cintent

K

Keith

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

Dave F

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
 
M

mike_vr

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
 
Top