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 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