Quick Tip – Splitting Names in Excel (Formula) Splitting names in Excel: =LEFT(B1,FIND(” “,B1,1)-1) =RIGHT(B1,LEN(B1)-FIND(” “,B1,1))