» Reversing the Word Order within a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Reversing the order of words in each of the two-word strings in column A.
Solution:
Use the RIGHT, LEN, FIND, and LEFT functions as shown in the following formula:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
Book Store:
Recommended Books:
- Windows XP for Dummies
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.
