» Separating First and Last Names Without Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To separate first name and last names:1. Select Column A or the range of cells containing the list of names.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select Delimited.
4. In Step 2 of 3, select the Space checkbox.
5. In Step 3 of 3, in the Destination box, select cell B1, and then click Finish.
Book Store:
Recommended Books:
- Microsoft Excel 2002 Simply Visual
- Monte Carlo Methods in Finance
- Special Edition Using Microsoft Outlook 2002
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Windows XP All-in-One Desk Reference For Dummies
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
