Skip to content

Instantly share code, notes, and snippets.

@knorthfield

knorthfield/numbers_explode.txt

Created May 31, 2016 09:54
Show Gist options
  • Save knorthfield/2329e6a1dd0618a50e71aee42564c649 to your computer and use it in GitHub Desktop.
Save knorthfield/2329e6a1dd0618a50e71aee42564c649 to your computer and use it in GitHub Desktop.
Download ZIP
Formulas for numbers to get first and last name from full name
Raw
numbers_explode.txt
LEFT(A2,FIND(" ",A2)−1)
RIGHT(A2,LEN(A2)−FIND(" ",A2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment