Splitting names in Excel:

=LEFT(B1,FIND(” “,B1,1)-1)

=RIGHT(B1,LEN(B1)-FIND(” “,B1,1))

Skip to content
# Quick Tip – Splitting Names in Excel (Formula)

Tidbits and snippets for Computing Teachers

Splitting names in Excel:

=LEFT(B1,FIND(” “,B1,1)-1)

=RIGHT(B1,LEN(B1)-FIND(” “,B1,1))