» Reversing Strings
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem:Converting the full names in column A, formatted "LastName, FirstName" into names formatted "FirstName LastName".
Solution:
Use the RIGHT, LEFT, LEN and FIND text category functions, as follows:
=RIGHT(A2,LEN(A2)-FIND("","",A2)-1)&"" ""&LEFT(A2,FIND("","",A2)-1)
Example:
Full Name_________Result
Seinfeld, Jerry___Jerry Seinfeld
Bush, George______George Bush
Jordan, Michael___Michael Jordan
Bowie, David______David Bowie
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Now, Discover Your Strengths
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The New Financial Order: Risk in the Twenty-First Century
- Accounting for Dummies
No comments have been submitted.
