How to replace a word or characters with another word in a column?

[maddoxs]

I tried using a filter for this to replace all rows that have 3001 to be changed to 1380. Is there a different way to get this to work? Thank you all

[IraWatt]

Hey @maddoxs,

You have one to many brackets at the end the formula should be:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Watermark]

Try placing a "tostring" in front :    Replace(tostring([number]),'3001', '1380')

[maddoxs]

Once I close the bracket at the end it stops showing colors. 

[IraWatt · Accepted solution]

The issue is that replace function only works on text data not numeric. Your data most likely comes in as a integer (number data type):

You can convert it to a string/text data type with a select tool:

Or you can use the two string method as @Watermark suggested.

The community has some quick and easy videos on formulas and the Formula Tool here Writing Expressions 

[Watermark]

If you want to leave it as a number, you could also go with an  "If Then" statement 

if [number]=3001
then 1380
else [number]
Endif

However this will only change that 1 number, so if it's just a replace that 1 then cool, otherwise you'll have to expand to take other options into account.

[IraWatt]

Great point @Watermark 😅 !