Thank you.

I have attached a stripped down version of the file with formula and code

I got the code from the following site - which was really helpful. But I can't seem to get the formula to work anymore. It seemed to stop - perhaps I am using the wrong file type - or I inadvertently changed something important

hhttp://www.cpearson.com/excel/stringconcatenation.aspx

Again, appreciate any help

thanks.

Attached Files

Data.xlsm (59.7 KB, 12 views)