Excel - Replace multiple words | Power Query 07
In this tutorial about Excel Power Query, you will see how to replace multiple words in text form list in Excel Power Query. Excel Power Query 07
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
--⏱️Timestamps⏱️--
00:00 | Introduction and Importing data to Power Query
01:58 | Paste M code from Internet
02:56 | Step by step solution
04:12 | Empty step: copy first query
05:13 | Split text by space in each row
06:27 | Adding column from previous step
08:06 | Replace words from list
09:32 | Combine all words
10:00 | Clean up and export result
11:34 | End
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelAndAdam #ExcelTips #excel