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 thanks!
3 Replies
Hi again
I created a sample Excel file for you with each one of the 4 functions mentioned in previous reply.
On sheet 2 of the sample file, I used one fifth method , which might be the easiest: it's Flash Fill
Note that:
Concat & TextJoin are available in Office 2019 & Office 365
Flash Fill is available in Office 2013 and later
Hope that helps
Nabil Mourad
- It looks pretty ugly but does TEXTJOIN meet your requirements? =""""&TEXTJOIN(""",""",FALSE,cells)&""""
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 Girvinhttps://www.youtube.com/watch?v=qALXjobSAMA
Hope that helps
Nabil Mourad
