|  

» Extract all the words except the first in Microsoft Excel

Enter the following text in cell A1: Are you going to Disneyland?

Use the following function:
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

The result: you going to Disneyland?


Rate This Tip
12 34 5
Rating: 3.51     Views: 22606
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments