How to delete street number from address

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...

How to Separate street number from address

Monday, 13 October 2014

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

comments | | Read More...