Put CSV row data into 1 cell

JKPieterse thank you for your reply.

I have this version: Microsoft Office 2019 Home & Student.

Now I am not sure if I don't get it to work because I can't use the formula because of my version. Or because I am doing something wrong.

In the enclosed image I showed what I did. Hopefully you can tell me what I did wrong.

Now I want to emphasize one thing. It is important that the string in C1 is used. Because I have to input this string in another programm. So the result of the formula has to be exactly this in the end: name= 'Tim' OR name = 'Jack' OR name = 'Anne' OR name = 'Ali' OR name = 'Emma'  

I appreciate your help. Thank you.

Kind regards,

Jeroen