» 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:
- Seven Habits Of Highly Effective People
- Windows XP Pocket Reference
- Advanced modelling in finance using Excel and VBA
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Fish! A Remarkable Way to Boost Morale and Improve Results
No comments have been submitted.
