entrptaher/Split first name last name.md

Created August 16, 2019 11:24

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/entrptaher/d345a8f03f95406da2fd17b3a23e7d48.js"></script>
Save entrptaher/d345a8f03f95406da2fd17b3a23e7d48 to your computer and use it in GitHub Desktop.

Raw

If the full name is in A1 column, then copy the following and paste on another column. Select all rows and paste to those cells as well.

=IF(ISERROR(split(substitute(REGEXREPLACE(A1, "[^a-z. A-Z]+", "")," ","~",1),"~")),,split(substitute(REGEXREPLACE(A1, "[^a-z. A-Z]+", "")," ","~",1),"~"))