Change Case

Power Query converts text to UPPERCASE, lowercase or Capitalize Each Word in two clicks, and the result refreshes when the source changes. Use Transform to change a column in place, or Add Column to keep the original. WhereTransform → Format, or Add Column → Format M functionsText.Upper, Text.Lower, Text.Proper Works inExcel 2016 and later, Power … Read more