Forum Discussion
reverse text to columns for .csv import
Hello, I want to reverse the text to columns function, so have the different columns in one again, instead of separated by tab I want them to be separated by commas, for .csv import. Any tips? Many t...
Hi
you can use either the Old function "Concatenate" or the new one "Concat"
You can also use the Joining operator of Excel "&" (Shift +7)
= A1&","&B1&","&C1 >> A1,B1,C1
Finally there is another function that allows you to set the delimiter one: it's the TextJoin Function
Here is a Tutorial by Excel Guru Mike Girvin
https://www.youtube.com/watch?v=qALXjobSAMA
Hope that helps
Nabil Mourad