» 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:
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- PowerPoint® 2002 For Dummies®
- Business Plans Kit for Dummies (With CD-ROM)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- How to Read A Financial Report
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
No comments have been submitted.
