Excel: Remove Everything After a Character 

=LEFT(A1, FIND(“?”, A1&”?”)-1)

Source: Excel: Remove Everything After a Character (like a question mark, comma or underscore) – Jeff Clark’s Blog

Leave a Reply

Your email address will not be published.