View showing empty fields as NULL: how to show nothing/blank instead?

View showing empty fields as NULL: how to show nothing/blank instead?

Hi,

In a form, I have two picklists which can be selected, or left empty. I then have a formula field which gathers these picklists in one field using the calculation picklist1 + picklist2.

In a view based on this form, I have the formula field showing, but whenever any one of the picklists have been left empty, the column shows the word "null" instead of a blank.

How do I get rid of the word "null", and just list an empty field if nothing has been selected?