Hi,

Can someone please help me with an array formula for
adding 'TEST' text to all the elements in the Column A.

So the column A should look like 'TEST' + original
contents.

It should not append 'TEST' if the value is NULL.

Cheers,
Sanka