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