9/28/2023 0 Comments Kutools excel find and replaceGo to the Data tab then press the From Table/Range command to import them into the power query editor. We then need to import these tables into power query. ![]() The important thing is the find column is on the left and the replace column is on the right. The columns can actually be named anything, as we won’t be referring to them by name. This is a table of the pairs of items to find and replace. ![]() ![]() We also have a table with two columns called Find and Replace and it’s been named MyFindReplace. ![]() In this example, we have a small table with one column called Job Title and the table has been named MyData. This is the data we’re going to transform with our find and replace function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |