Forum Discussion

Kalthof's avatar
Kalthof
Brass Contributor
Feb 26, 2020
Solved

Put CSV row data into 1 cell

Dear community,   Today I spent some time to figure out how I could put all the rows of my CSV file into 1 cell.   I have a list with hundreds of names. And I need all of them to be put in betwee...
BI & Data Analysis
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 27, 2020
If you have the latest version of Office 365 you can use this:
="name = '"&TEXTJOIN("' or name = '",TRUE,A1:A4)&"'"
  • Kalthof's avatar
    Kalthof
    Brass Contributor
    Feb 27, 2020

    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

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Feb 27, 2020

      Kalthof See attached. The last cell in column B contains the string you need.

      • Kalthof's avatar
        Kalthof
        Brass Contributor
        Feb 27, 2020

        JKPieterse Yes that is the string I need. But how do I automate it so I don't have to type this string out for hundreds of names? 

         

        So what do I have to put in an empty cell to build 1 huge string?

         

        I want for every name this 'phrase' added to the string: OR name = 'Emma'. And the name between the quotes is depended on what the name is in the next row. 

Resources