Monday, 29 February 2016

Simple formula to split First and Last Name

First Name

=LEFT(A1,(FIND(" ",A1,1)-1))

Last Name

=RIGHT(A1,(FIND(" ",A1,1)-1))
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)