Learn several ways you can change text case in Excel. Use one of standard Excel functions; see a special add-in that allows you to capitalize the first character in each cell or update the selected values to lowercase, UPPERCASE, , or Proper Case; or employ Flash Fill in Excel.
See also: 4 ways for changing text case in Excel 2016, 2013, 2010
https://www.ablebits.com/office-addin...