Another important feature of Power Query is Formatting Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature.
Format Columns By Power Query
Step 1: Select Columns for Formatting
As shown in below picture, the data table contains employee data where employee names are given in lower case. To format these names we have to first select the entire column.
Step 2: Capitalize each word for the selected column
To capitalize each word in Power Query, go to-
Transform > Text Column > Format > Capitalize Each Word option
Step 3: Close & Apply
After you get the expected result as shown in the below picture, click on the Close & Apply button to save the changes.
You can learn more :
- Top 5 Steps to Extract Age Using Date in Power Query
- Split Column By Number Of Characters in Power Query
- Learn How to Append Queries in Excel
- Steps to Merge Columns in Excel