Courses / Power Query (Get & Transform)
13. Replace Values
Replacing occurrences of a value in a column using the Replace Values action or Text.Replace in M.
1 min read Chapter 13 of 43
Power Query M
Replace Values
Changing occurrences of a value or substring in a column to a new value in Power Query.
"I want all 'NY' and 'ny' to become 'New York' without editing rows one-by-one."
Replace Values changes matching text (whole-cell or substring) in a column; in M you can use helpers like Text.Replace or Table.ReplaceValue for flexible rules.
"I want all 'NY' and 'ny' to become 'New York' without editing rows one-by-one."
Replace Values changes matching text (whole-cell or substring) in a column; in M you can use helpers like Text.Replace or Table.ReplaceValue for flexible rules.