Pages - Menu

Monday, 13 October 2014

How to delete street number from address

How to delete street number from address

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

No comments:

Post a Comment