Sunday, January 13, 2013

How to Separate the First Name Last Name in Excel


1. Open Excel 2010 and click the 'File' tab. Select 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Highlight the column containing the combined first and last name. Right-click the column and select 'Insert' to insert a blank column. This will provide the column for the last name once the split has occurred.
3. Click the 'Data' tab and click 'Text To Columns.' The Text To Columns dialog box appears. Click 'Next' and check 'Space.' Click 'Finish' to split the first and last name in the workbook.

Blogger news