Adding data in column to a cell

Okay, so that works on the test sheet, but when I input it with real values, I get a #VALUE! error.

The difference is the ID's are something like
RLP300500

And the certs are like:

Certified Microsoft Fundamental person