CATEGORY: Excel Editing VERSIONS: All Microsoft Excel Versions

To separate the name John Smith, in cell A1, use two formulas: The formula that extracts the first name is: =LEFT(A1,FIND(" ",A1)) The formula that extracts the last name is: =MID(A1,FIND(" ",A1)+1,LEN(A1)) The FIND formula returns the starting position of one text string within another text string.

Screenshot // Separating First and Last Names Using Formulas

Rate this tip 1 2 3 4 5   RATING: 4.49   VIEWS: 29337 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Analyzing Markets, Products, and Marketing Plans Fish! A Remarkable Way to Boost Morale and Improve Results The One Page Business Plan: Start With a Vision, Build a Company! Keys to Reading an Annual Report (Barron's Business Keys) Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed) Microsoft Windows XP Inside Out

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books