Seperating an Address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
only for the FIRST space. use
=LEFT(A1,FIND(" ",A1)-1)

and
=MID(A1,FIND(" ",A1)+1,1024)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Un-Concatenate 3
Word Create a Phone Book using MailMerge in word 2007 0
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
How do I compare the stored data in micro 3
Split cell based on UPPERCASE text 1
help on a vlookup please 5
Replacing a formula with the actual string or number 1

Back
Top