The Name? error usually means that your formula is looking for a named range rather than a reference. Double check your formula to ensure quotes are in the right place. I would use this formula =if(a3="","",a1&";"&a2&";"&a3) etc.

If this dosnt solve the issue, go ahead and post your workbook.