LinkBack URL
About LinkBacks
Have about 200,000 rows of data and need to separate address number from street name. I can do a Text/columns but would rather have a formula. Thanks
Have about 200,000 rows of data and need to separate address number from street name. I can do a Text/columns but would rather have a formula. Thanks
Use this:
=LEFT(A1,SEARCH(" ",A1)-1)+0
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If you can have addresses like 100A Mickey Mouse Avenue, then use:
=LEFT(A1,SEARCH(" ",A1)-1)
However all values will then be returned as TEXT. In this case, that is probably not an issue for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks