Dear Forum



I am trying to concatenate some text values with semi colons in between, ignoring cells with no entry

I used with initial great success the string concat function by Pearson, by placing code in to my sheet and using the =StringConcat function

BUT, All worked well but then it seemed to stop working and my formula gave #NAME? errors everywhere I used it.
Its almost like something just stopped working

Any ideas why? is it some setting on my Excel?

Should I go about the concentration differently?

Appreciate any help at all

Thank you