» Extracting a substring
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Listed in column A are full or first names.
How could we create a new column B containing the first names extracted from each name in column A?
Solution:
Using the FIND, RIGHT and LEN text category functions in this IF statement:
=IF(ISNUMBER(FIND("","",A2)),RIGHT(A2,LEN(A2)-FIND("","",A2)-1),A2)
Example:
Names_______________First Names
Bush, George________George
Seinfeld, Jerry_____Jerry
Jordan, Michael_____Michael
Laura_______________Laura
Kate________________Kate

Book Store:
Recommended Books:
- Analysis of Financial Statements
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Accounting the Easy Way
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
No comments have been submitted.

