I have two columns of text, Column A, Column B, sometimes Column A is blank, sometimes Column B is blank, sometimes one has text, sometimes both have text. I want to use the MCONCAT(A1:B1,";") function to return whatever the values are in those two cells. However I only want to return the ";" when there are two values. If the result is "null" or only one value, there doesn't need to be a ";".