It is now very easy to split a name into first name and last name, using Excel, even if the name is in a single column. Text to Column Function in Microsoft Excel 2003 1. Select the data in Excel. 2. Go to the Data Menu, and select Text to Columns 3. Choose Delimited, and click the Space checkbox, and click Finish. 4.  The data would have been split into separate columns. Text to Column Function in Microsoft Excel 2007 [...]