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