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)
Labels:
Excel
Subscribe to:
Post Comments (Atom)
.JPG)
Posts
No comments:
Post a Comment