In this tutorial, I show how to split first and last names in Excel using the TEXTSPLIT function. • Select the cell where you want the names to be split • Type =TEXTJOIN • Press TAB on your keyboard • Select the cell with the name, then type a space in quotation marks and press Enter
