N/A to Null with Replace not working as intended

[jwlam]

Hi everyone!

I'm having trouble with the Replace formula not giving me the output I would expect.

I want N/A values to be replaced with nothing so it reads as Null. When using "Replace("N/A", [Value], "")" the output is still N/A for some reason. I'm not sure where I've gone wrong.

[IraWatt · Accepted solution]

Hey @jwlam,

Think you have your formula parameters in the wrong order it should be Replace([Value],"N/A", ""):

This will replace the column values with blank. If you want to replace the values with NULL try this:

IF [Value]="N/A" THEN Null() ELSE [Value] ENDIF

Any questions or issues please ask :)
HTH!
Ira

[Qiu]

@jwlam 
@IraWatt gives very detailed comments and samples.

Lets refresh with the syntax 😂

[jwlam]

Thanks for the explanation @Qiu. I totally had it backwards haha. 

[jwlam]

Thanks @IraWatt. That totally worked!

[IraWatt]

Thanks @Qiu 😄 The formulas are always important for clarification ! Glad it worked for you @jwlam :D