Seperating an Address

C

Charlie

I have a list of street addresses and I would like to extract out the street
name to a seperate column. I have tried to use text to columns but it splits
the address on each space and thus street names that are two words end up in
two columns. I was thinking if I could get "Text to Columns" to split on the
first space only that would work. If anyone has any ideas I would sure
appreciate it.
 
F

Frank Kabel

Hi
only for the FIRST space. use
=LEFT(A1,FIND(" ",A1)-1)

and
=MID(A1,FIND(" ",A1)+1,1024)
 
Top