Hi - I need to concatenate two columns if the 2nd one contains anything - any character at all.
So far I have
IF contains([COLUMN 2],' ') THEN [COLUMN 1] + [COLUMN2]
ELSE [COLUMN 1]
ENDIF
I know the ' ' is incorrect as it includes empty cells, but how do I write for IF a cell contains any data?
Or does it need a notNull or not empty?
EDIT: Figured it out using notNull:
IF IsNull([Col 2]) THEN [Col 1]
ELSE [Col 1] + ' ' + [Col 2]
ENDIF
Solved! Go to Solution.
Hi, you can use the !IsNull() or !IsEmpty() formulas. The exclamation mark at the beginning means the oposite, so 'is not null' for instance.
Worth noting that IsEmpty picks up both nulls and empty cells, whereas IsNull would not count empty cells