» Extracting Characters from Text Without Using Formulas
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To extract characters from text:1. Select column A.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select Fixed width, and then click Next.
4. In Step 2 of 3, parse the data in the column by clicking the mouse between columns as needed for parsing, and then click Next.
5. In Step 3 of 3, in the Destination box, enter cell B1, and then click Finish.
Book Store:
Recommended Books:
- Analysis of Financial Statements
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- East of Eden (Oprah's Book Club)
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
