Table.ReplaceValue [Applies to Power Query]

This topic applies to the Power Query Formula Language. With Power Query you can discover, combine and refine data. To learn more about Power Query formulas in Excel, see Create Power Query formulas in Excel. For Excel VBA help, see Excel 2013 developer reference.

About

Replaces oldValue with newValue in specific columns of a table, using the provided replacer function, such as text.Replace or Value.Replace.

Table.ReplaceValue(table as table, oldValue as any, newValue as any,replacer as function, columnsToSearch as {Text}) as table

Arguments

Argument

Description

table

The Table to modify.

oldValue

The old value to modify.

newValue

The new value to replace with.

replacer

The replacer function to use, such as Text.Replace or Value.Replace.

columnsToSearch

The list of columns to search through.

Examples

Table.ReplaceValue(
    Table.FromRecords(
{
    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
}
),
    "Bob",
    "New Customer Name",
    Text.Replace, {"Name"})

CustomerID

Name

Phone

1

New Customer Name

123-4567

2

Jim

987-6543

3

Paul

543-7890

4

Ringo

232-1550

Applies To: Excel 2010, Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language