N/A to Null with Replace not working as intended

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.

Output

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

IraWatt

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

Workflow.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703