How to delete street number from address - Blogging Brain

News Update :

Home » Excel Tips , How-To » How to delete street number from address

How to delete street number from address

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

How to delete street number from address

=IF(ISERR(--LEFT(A1,FIND(" ",A1))),A1,MID(A1,FIND(" ",A1)+1,100))

Post a Comment

Subscribe to: Post Comments (Atom)

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