Replace a Field Value

[traceystone]

Hello. What is the best way to replace a value found in a column with another value? Example: I want to find all 615551 values in the GLAccount column and replace it with 610000. 

GLAccount

615551

610000

615000

642510

615551

[Luke_C · Accepted solution]

Hi @traceystone 

Here's two ways, one with the Replace() formula, and one with the find and replace tool.

[MeganBowers · Accepted solution]

Hi! To do that you can use a formula tool with the formula: Replace( [GLAccount], 615551, 610000). If the column is a text column, you will need quotes around the numbers in the formula. Hope this helps!