Replace values (Power Query) - Microsoft Support (2023)

The default behavior for text values is to search and replace a specific text string. This behavior canbe changed.

1. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

   See Also

   Disabling a button once it is pressedUse controls for model-driven app data visualizations in Power Apps - Power AppsHow to customize power button action when pressed on Windows 10I want to understand the difference between delete remove and pop in Python

2. Select a column with a text data type.

3. Select Home or Transform > Replace Value. TheReplace Values dialog box appears.

4. In the Value To Findbox, enter the value to search.

5. In theReplace Withbox, enter the value to replace.

6. Under Advanced options, do one or more of the following:

   Match Bydefault, specific text values are replaced. To replace the the whole cell value, selectMatch entire cell contents.

   (Video) Replace Values Based on Condition (in a Single Step) in Power Query

   Special characters To handle special characters, select Insert special characters and then select one of the following from the drop-down list:Tab, Carriage Return, Line Feed,Carriage Return and Line Feed, and Non-breaking Space.

7. SelectOK.

   See Also

   What is the difference between pop and removeUninstall or remove apps and programs in WindowsCan't Delete Photos from Android Gallery, How to FixRemove Elements From Lists | Python List remove() Method | Edureka

The default behavior for non-text columns is to search and replace the full contents of a cell. This behavior can’t be changed.

1. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

2. Select a column with a number, date/time,or logical data type.

3. Select Home or Transform > Replace Value. TheReplace Values dialog box appears.

4. In the Value To Findbox, enter the value to search.

5. In theReplace Withbox, enter the value to replace.

6. SelectOK.

   See Also

   What are the two ways to remove something from a list? how are they different? – techtipnowHow to Clear Your Android Cache & Why You Should Do ItC program to delete a file - GeeksforGeeksIn Unix, how do I remove a directory?