RIGHT( cell, LEN( cell) - SEARCH(' ', cell)) The first name can be easily extracted with this generic formula: These formulas cover the most typical scenario when you have the first name and last name in one column separated by a single space character. How to split first and last name from full name with space However, if you plan to make any changes to the original names and are looking for a dynamic solution that will update automatically, you'd better divide names with formulas. As the Destination, specify the topmost cell in the column where you want to output the results (please keep in mind that this will overwrite any existing data, so be sure to choose an empty column).ĭone! The first, middle, and last name are divided into separate columns: Separate first and last name in Excel with formulasĪs you have just seen, the Text to Columns feature is quick and easy. The default General format works nice in most cases. On the last step, you select the data format and destination, and click Finish.If you are dealing with names separated with a comma and space like Anderson, Ronnie, then check the Comma and Space boxes under Delimiters, and select the Treat consecutive delimiters as one checkbox (usually selected by default).
