In cell B2, type =PROPER(A2), then press Enter.

Source: Change the case of text – Office Support

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

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