In this example, everything starting with the "?" is removed from text in cell B7:
=IF(ISNUMBER(FIND("?",B7)),LEFT(B7,FIND("?",B7)-1),B7)
Tuesday 26 May 2009
Excel Formula to Remove Text after Specific Character
Posted on 09:38 by Unknown
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment