|  

» Extract the last word in a cell in Microsoft Excel

CATEGORY - Excel Text , Excel Formula VERSION - All Microsoft Excel Versions
Enter the following text in cell A1: Are you going to Disneyland?

Use the Following Function:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

The result: Disneyland?


Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 4.67     Views: 43417
Extract the last word in a cell in Microsoft Excel
rami
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation