» 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 Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- The One Page Business Plan: Start With a Vision, Build a Company!
- Keys to Reading an Annual Report (Barron's Business Keys)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
