How to delete or remove the first two words in a cell

For example, you have the following  text in a cell “A1″ and you’d like to remove the first two words:

“English courses USA”

To remove the first two words “English courses” from A1, use the following formula:

=MID(A1,1+FIND("~",SUBSTITUTE(A1," ","~",2)),255)

The result:

USA

Not working for you?

Remember to replace A1 with the cell that contains the string of words you want to parse out.

This entry was posted in Extracting words. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>