Formulas in VBA runtime Error 1004

Can seem to find an issue like this on google.
I just don't understand.

Receiving a runtime error 1004 which highlights the second code snippet below.
"Application-Defined or Object-Defined error"

This works:

Formula:

    ws.Range("A16").Value = "=IF(G16=""X"",IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($A$2:$A$15,B16)))))>0,""X"",""N""),""N"")"

    ws.Range("A16").Copy

    ws.Range("A17:A1500").PasteSpecial Paste:=xlPasteFormulas

This doesn't work:

Formula:

    ws.Range("E16").Value = "=TRIM(CONCATENATE(LEFT(B16,FIND("","",B16)-1),"" "",MID(B16,FIND("" "",B16)+1,FIND("","",B16)))"

    ws.Range("E16").Copy

    ws.Range("E17:E1500").PasteSpecial Paste:=xlPasteFormulas

The 2nd code is directly following the first.

Any ideas?