Tuesday, May 26, 2009

Excel Formula to Remove Text after Specific Character

In this example, everything starting with the "?" is removed from text in cell B7: =IF(ISNUMBER(FIND("?",B7)),LEFT(B7,FIND("?",B7)-1),B7)
Print Friendly and PDF
Posted by Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
Related Posts Plugin for WordPress, Blogger...