Excel GuideMarch 2, 2026How to Split Names into First and LastData Cleaning\n\nUse the "Text to Columns" feature or the new TEXTSPLIT function to separate names easily.\n\n=TEXTSPLIT(A1, " ")