|
In response to
"ST is best tech support: Excel: I have a spreadsheet full of addresses, but would like to split the address line into two (house number/street name)."
by
Name Withheld By Request
|
If the format of them all is "1234 main st.", you can do the following to make sure you don't get spaces
Posted by
JaxSean (aka JaxSean)
Jul 31 '14, 10:20
|
to get the number:
=LEFT(A1,FIND(" ",A1,1))
to get the street part:
=RIGHT(A1,(LEN(A1) - FIND(" ",A1,1)))
|
Responses:
|