Home

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

@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

Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using the CONCATENATE function and the Ampersand. See some amazing new and more efficient uses that ...
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