» Reversing the Word Order within a String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Marketing Planning for Services
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Special Edition Using Microsoft Access 2002
- Mortgages For Dummies®
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Retire Young, Retire Rich
No comments have been submitted.
