» Rearranging a String in Alphabetic Order
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
The cells in column A contain 3-letter strings.
We want to rearrange each string so that its characters are sorted in alphabetic order.
Solution:
Use the CHAR, SMALL, CODE, and MID functions as shown in the following formula:
=CHAR(SMALL(CODE(MID(A2,{1,2,3},1)),1))&CHAR(SMALL(CODE(MID(A2,{1,2,3},2)),2))&CHAR(SMALL(CODE(MID(A2,{1,2,3},3)),3))
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft PowerPoint Version 2002 Step by Step
- Word 2002: The Complete Reference
- The Ernst & Young Business Plan Guide
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
