News Update :

How to delete street number from address

By: Unknown on Monday, 13 October 2014 | 08:14

Monday, 13 October 2014

How to delete street number from address

=IF(ISERR(--LEFT(A1,FIND(" ",A1))),A1,MID(A1,FIND(" ",A1)+1,100))
comments | , | Read More...
Posted by Unknown 0 comments
Labels: ,

How to Separate street number from address

=IF(ISNUMBER( VALUE(LEFT(A1,1))), LEFT(A1,SEARCH(" ",A1)-1), "")
comments | , | Read More...
Posted by Unknown 0 comments
Labels: ,
Subscribe to: Posts (Atom)

Download

Blog Archive

 
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