fbpx
Email: [email protected] Call Now! +1 203-349-9909 / +91-8080042523

Steps to Format Columns Using Power Query

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.

SELECT COLUMN FOR FORMATTING

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

CAPITALIZE EACH WORD FOR SELECTED COLUMN

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.DATA TABLE AFTER FORMATTING COLUMN

You can learn more :

Leave a Reply