=LEFT(A1, FIND(“?”, A1&”?”)-1)
Source: Excel: Remove Everything After a Character (like a question mark, comma or underscore) – Jeff Clark’s Blog