In cell B2, type =PROPER(A2), then press Enter.
Tag: Excel
-
Change text in Excel to Sentence Case
-
Excel: Remove Everything After a Character
=LEFT(A1, FIND(“?”, A1&”?”)-1)
In cell B2, type =PROPER(A2), then press Enter.
=LEFT(A1, FIND(“?”, A1&”?”)-1)