Forum Discussion
Put CSV row data into 1 cell
Kalthof See attached. The last cell in column B contains the string you need.
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
Kalthof See attached. The last cell in column B contains the string you need.
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.
- Haven't you seen the formulas in the cells?
Sorry Jan Karel. I only opened the preview. Didn't see that it was an excel file. My excuse.
This is exactly what I need. I appreciate it a lot. Wouldn't have been able to figure this out myself.
Have a great day.
Kind regards,
Jeroen