» Separating First and Last Names Without Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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 Outlook 2002 for Dummies
- Microsoft Windows XP Registry Guide
- Business Plans Kit for Dummies (With CD-ROM)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
