Quick Tip – Splitting Names in Excel (Formula)

Splitting names in Excel:
=LEFT(B1,FIND(” “,B1,1)-1)
=RIGHT(B1,LEN(B1)-FIND(” “,B1,1))