Replace values with text contains

Might be easiest to add a column:

= Table.AddColumn(TableName, "Corrected", each if Text.Contains([User], "@school1.com") then "school1" else [User], type text)

--Nate