» 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:
- Mastering Excel 2000 (for beginner)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Windows XP Annoyances
- The Intelligent Investor: The Classic Bestseller on Value Investing
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Marketing Plan: A Handbook with Marketing Plan
No comments have been submitted.
