Use CTRL + E shortcut to split first and last name
There are other popular ways of splitting first name and last name such as using LEFT and RIGHT functions, Text to column and also using Power Query. The CTRL + E shortcut is some sort of AI capability in Microsoft Excel. Spread the word