Formula to identify any character in a column?

Question

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

Luke_C · Accepted Answer

Worth noting that IsEmpty picks up both nulls and empty cells, whereas IsNull would not count empty cells