To get the number portion: =LEFT(A1,FIND(" ",A1,1)-1)
To get the address: =MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1)+1)
To get the number portion: =LEFT(A1,FIND(" ",A1,1)-1)
To get the address: =MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1)+1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks