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:


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.

One Comment

  1. Sanjay Maurya
    Posted January 10, 2015 at 12:31 am | Permalink


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=""> <s> <strike> <strong>