Excel – Remove All Text After Specified Character

Posted: June 10th, 2011 | Author: | Filed under: excel, windows | 1 Comment »

This excel function searches the cell ‘V22′ for the ‘greater than’ character. If it is found then it will remove that character and everything after it. If not found then it will copy V22′s value.

=IF(ISNUMBER(SEARCH(">" , V22)) , LEFT(V22,FIND(">",V22,1) - 1) , V22)
Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Reddit
  • RSS
  • StumbleUpon

Related posts:

  1. Remove New Tab Button From Firefox 3.5

One Comment on “Excel – Remove All Text After Specified Character”

  1. 1 Timberland shoes sale said at 3:36 am on November 19th, 2011:

    Great post, I believe people should larn a lot from this weblog its real user friendly. So much excellent info on here :D .

Leave a Reply