Jul 26 2019 09:06 AM
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!
Jul 26 2019 09:19 AM - edited Jul 26 2019 09:21 AM
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
Jul 26 2019 09:27 AM
Jul 26 2019 10:29 AM
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