Below in the link to a tutorial on splitting text from a single field. It can be done without using formulas in the first option, but you can use formulas as well. The one thing to be cautious of is when there is not consistency with clients using a middle name or initial vs. clients with just first and last name. The splitting of text may not be consistent across both since there are three column splits vs. two column splits.
https://www.ablebits.com/office-addins-blog/separate-first-last-name-excel/