There are a few ways to split a first and last name in Excel. One way is to use the TEXTJOIN function. The TEXTJOIN function will allow you to join text values together, and it will allow you to specify a delimiter. In this case, you would use a space as the delimiter. Another way to split a first and last name is to use the TRIM function. The TRIM function will remove any spaces at the beginning or end of a text value. Finally, you could use the SUBSTITUTE function. The SUBSTITUTE function will allow you to replace a text value with another text value. In this case, you would use a space as the replacement text.