Concatenate with a condition

[Ms_Silver]

Hello! I have an expression where I'm trying to concatenate two columns. For their values I would like to have a slash (/) between them. However, I don't want the slash if either values are blank, only if both are filled. Could someone please help? Thank you for the help in advance.

Here is my expression:

[NOTE]&" / "&[CONDITION]

[diogolupcosta · Accepted solution]

IF(

AND(ISNOTBLANK([NOTE]), ISNOTBLANK([CONDITION])),

[NOTE]&" / "&[CONDITION],

[NOTE]&" "&[CONDITION]

)

[Luis_Rodriguez_]

isnt this working? the logic seems correct.

[Ms_Silver]

Yes!! Thank you so much, diogolupcosta. This worked!

[dbaum]

May be more complexity that is warranted for your scenario, but here's an extensible technique to Concatenate values with a delimiter. 

[Ms_Silver]

Thank you for chiming in, dbaum. I will look at this too. Seems complex but fascinating.

[SkrOYC]

Btw, there will be a blank space if either of the two are blank, right?

[Ms_Silver]

Yes, it will be blank space if either are blank. For my use, this is fine.

[dbaum]

TRIM([NOTE]&" "&[CONDITION])