First Name Last Name Separation

An Excel file that teaches how to perform First Name Last Name Separation operation.

Excel First Name Last Name Separation

Division logic is applied via the space character. Middle name and surname scenarios are taken into account. Flexible formulas are established with text functions. A check for incorrect entries is added. Results are reported in separate columns.

Hope it is useful.