Extracting All but the First Word of a String in Excel 2007

Excel Formula Add comments

The following formula returns the contents of cell A1, except for the first word:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

If cell A1 contains 2007 Operating Budget, the formula returns Operating Budget.

This formula returns an error if the cell contains only one word. The formula below solves this problem and returns an empty string if the cell does not contain multiple words:

=IFERROR(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)),"")

For compatibility with earlier versions of Excel, use this formula:

=IF(ISERR(FIND(" ",A1)),"",RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))

Popularity: 4% [?]

Related Post

  • Extracting the First Word and the Last Word of a String
  • Extracting Characters from a String in Excel 2007
  • Extracting a Person’s First Name or Last Name in Excel 2007
  • Searching and Replacing within a String in Excel 2007
  • Counting Specific Characters in a Cell and the Occurrences of a Substring, excel 2007
  • Don't Find What You're Looking For? Please Try Here...

    Google
     

    Leave a Reply

    WP Theme & Icons by N.Design Studio
    Entries RSS Comments RSS Add to Technorati Favorites Log in