reverse text to columns for .csv import

%3CLINGO-SUB%20id%3D%22lingo-sub-775236%22%20slang%3D%22en-US%22%3Ereverse%20text%20to%20columns%20for%20.csv%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775236%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20want%20to%20reverse%20the%20text%20to%20columns%20function%2C%20so%20have%20the%20different%20columns%20in%20one%20again%2C%20instead%20of%20separated%20by%20tab%20I%20want%20them%20to%20be%20separated%20by%20commas%2C%20for%20.csv%20import.%20Any%20tips%3F%20Many%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EColumns%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecsv%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etabs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etext%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775286%22%20slang%3D%22en-US%22%3ERe%3A%20reverse%20text%20to%20columns%20for%20.csv%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382792%22%20target%3D%22_blank%22%3E%40milly87%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3Eyou%20can%20use%20either%20the%20Old%20function%22%20Concatenate%20or%20the%20new%20one%20Concat%3C%2FP%3E%3CP%3EYou%20can%20also%20use%20the%20Joining%20operator%20of%20Excel%20%22%26amp%3B%22%20(Shift%20%2B7)%3C%2FP%3E%3CP%3E%3D%20A1%26amp%3B%22%2C%22%26amp%3BB1%26amp%3B%22%2C%22%26amp%3BC1%26nbsp%3B%20%26gt%3B%26gt%3B%20A1%2CB1%2CC1%3C%2FP%3E%3CP%3EFinally%20there%20is%20another%20function%20that%20allows%20you%20to%20set%20the%20delimiter%20one%3A%20it's%20the%20Text%20Join%20Function%3CBR%20%2F%3EHere%20is%20a%20Tutorial%20by%20Excel%20Guru%20Mike%20Girvin%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqALXjobSAMA%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqALXjobSAMA%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775309%22%20slang%3D%22en-US%22%3ERE%3A%20reverse%20text%20to%20columns%20for%20.csv%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775309%22%20slang%3D%22en-US%22%3EIt%20looks%20pretty%20ugly%20but%20does%20TEXTJOIN%20meet%20your%20requirements%3F%20%3D%22%22%22%22%26amp%3BTEXTJOIN(%22%22%22%2C%22%22%22%2CFALSE%2Ccells)%26amp%3B%22%22%22%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775432%22%20slang%3D%22en-US%22%3ERe%3A%20reverse%20text%20to%20columns%20for%20.csv%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775432%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382792%22%20target%3D%22_blank%22%3E%40milly87%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20again%3C%2FP%3E%3CP%3EI%20created%20a%20sample%20Excel%20file%20for%20you%20with%20each%20one%20of%20the%204%20functions%20mentioned%20in%20previous%20reply.%3C%2FP%3E%3CP%3EOn%20sheet%202%20of%20the%20sample%20file%2C%20I%20used%20one%20fifth%20method%20%2C%20which%20might%20be%20the%20easiest%3A%20it's%20%3CSTRONG%3EFlash%20Fill%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%20that%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EConcat%20%26amp%3B%20TextJoin%20are%20available%20in%20Office%202019%20%26amp%3B%20Office%20365%3C%2FP%3E%3CP%3EFlash%20Fill%20is%20available%20in%20Office%202013%20and%20later%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@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

File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1280-1281.xlsx Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn about th...
Highlighted
It looks pretty ugly but does TEXTJOIN meet your requirements? =""""&TEXTJOIN(""",""",FALSE,cells)&""""
Highlighted

@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