@nickdavisio

  • Home
  • Notes

Tag: Excel

  • Change text in Excel to Sentence Case

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

    Source: Change the case of text – Office Support

    16 March 2021

    •

    Notes

    •

    Excel
  • 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

    16 March 2021

    •

    Notes

    •

    Excel