Using MCONCAT function to join value from multiple cells into one cell-HELP

[golfpromal]

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 ";".

[Pete_UK]

Why not just do the following:

=A1 & IF(OR(A1="",B1="")"",";") & B1

Hope this helps.

Pete