News Update :
Home » , » How to Separate street number from address

How to Separate street number from address

By: omer nawaz on Monday, 13 October 2014 | 08:12

=IF(ISNUMBER( VALUE(LEFT(A1,1))), LEFT(A1,SEARCH(" ",A1)-1), "")

Post a Comment

 
Contact Us | Privacy policy | Term of use | Advertise with Us | Site map
Copyright © 2011. Blogging Brain . All Rights Reserved.
Design Template by Blogging Brain | | Powered by Blogger