» 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:
- The 22 Immutable Laws of Branding
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The New Financial Order: Risk in the Twenty-First Century
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Windows XP Annoyances
- Yes, You Can Time the Market!
No comments have been submitted.
