Replace values (Power Query)

With Power Query, you can replace one value with another value in a selected column. You replace values in the Query Editor.

ShowLearn more about the Query Editor

You can access the Query Editor from the Navigator pane when connecting to a data source, or at any time from the Workbook Queries pane or the contextual Query ribbon tab for an existing query. To learn how to load the Query Editor, see Power Query Quick Start.

I want to


Replace text values

Using the Query Editor ribbon

  1. In the Query Editor ribbon, click Replace Values.

Using the Query Editor context menu

  1. Right-click a text cell, and click Replace Values.

To replace text values

  1. In the Replace Values dialog box, enter Value To Find and Replace With.
  2. Click Match entire cell contents option to replace cells from the entire contents; otherwise, Replace Values replaces each Value To Find match.
  3. Click OK.

Top of Page Top of Page

Replace number, Date/Time. or logical values

Using the Query Editor ribbon

  1. In the Query Editor ribbon, click Replace Values.

Using the Query Editor context menu

  1. Right-click a number or Date/Time cell, and click Replace Values.

To replace number, Date/Time. or logical values

  1. In the Replace Values dialog box, enter Value To Find and Replace With.
  2. Click OK.

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel 2010