Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Find and replace certain words in a string

Hi everyone,


I have a table with 7 columns and 12000 rows contains learners' survey results. 

One of the columns contains the students' comments (string). These strings may contain one or more lecturers' name.

I am trying to create a query using M language that allows me to identify the strings with the lectures' name and replace the lecturers' name with the word "Lecturer".

Also, another table includes the list of lecturers' name (1 column, 2000 rows).

I hope it makes sense.


Thank you,


Super User III
Super User III

There are many examples available for this requirement. Here's one of them: Bulk Find And Replace In Power Query | How To Excel

Regular Visitor

Thank you Ibendlin. Appreciate your response. 

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors