reverse text to columns for .csv import

Copper Contributor

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

@milly87 

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

It looks pretty ugly but does TEXTJOIN meet your requirements? =""""&TEXTJOIN(""",""",FALSE,cells)&""""

@milly87 

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