Importing .txt in Excel app. Cannot select specific or adjust columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1592893%22%20slang%3D%22en-US%22%3EImporting%20.txt%20in%20Excel%20app.%20Cannot%20select%20specific%20or%20adjust%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592893%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20Excel%20Community!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20import%20.txt%20in%20Excel%20app%20from%20Data%20%26gt%3B%20Get%20%26amp%3B%20Transform%20Data%20%26gt%3B%20From%20Text%2FCSV.%20I%20was%20able%20to%20do%20it%20using%20the%20traditional%20way%2C%20in%20which%20I%20was%20able%20to%20select%2Fadjust%20specific%20columns.%20Here%20is%20a%20screenshot%20provided%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Guillermo49_0-1597669442673.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212735i6314A5F2BB9881E1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Guillermo49_0-1597669442673.png%22%20alt%3D%22Guillermo49_0-1597669442673.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBut%20when%20I%20got%20to%20Data%20%26gt%3B%26nbsp%3B%20Get%20%26amp%3B%20Transform%20Data%20%26gt%3B%20From%20Text%2FCSV%2C%20I%20cannot%20seem%20to%20select%2Fadjust%20specific%20columns.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22s1.PNG%22%20style%3D%22width%3A%20886px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212736i7982C70DF0F77174%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22s1.PNG%22%20alt%3D%22s1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1592893%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593289%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20.txt%20in%20Excel%20app.%20Cannot%20select%20specific%20or%20adjust%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593289%22%20slang%3D%22en-US%22%3EIf%20you%20change%20the%20numbers%20in%20the%20box%20that%20currently%20contains%200%2C%2082%2C133%2C%20260%2C%20315%2C%20can't%20you%20get%20it%20to%20do%20what%20you%20want%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593904%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20.txt%20in%20Excel%20app.%20Cannot%20select%20specific%20or%20adjust%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593904%22%20slang%3D%22en-US%22%3EHi%20Jan%2C%3CBR%20%2F%3E%3CBR%20%2F%3EUnfortunately%2C%20it%20doesn't%20work.%20Please%2C%20see%20how%20to%20work%20the%20import%20wizard%20in%20Excel%202010%2C%202013%2C%20etc.%20in%20these%20section.%20I%20think%20it%20must%20be%20a%20kind%20of%20error%20or%20something%20wrong%20because%20before%20it%20worked%20very%20well.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EGuillermo.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601072%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20.txt%20in%20Excel%20app.%20Cannot%20select%20specific%20or%20adjust%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F761796%22%20target%3D%22_blank%22%3E%40Guillermo49%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20it%20shall%20work.%3C%2FP%3E%0A%3CP%3EIf%20after%20changing%20the%20numbers%20you%20click%20on%20Refresh%20icon%2C%20numbers%20will%20be%20returned%20in%20initial%20one.%20However%2C%20if%20instead%20to%20click%20on%20any%20empty%20cell%20in%20preview%20window%2C%20new%20numbers%20will%20be%20taken%20to%20show%20how%20the%20text%20is%20split.%3C%2FP%3E%0A%3CP%3EAlternatively%20you%20may%20Transform%20and%20correct%20numbers%20in%20formula%20bar.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good day Excel Community!

 

I am trying to import .txt in Excel app from Data > Get & Transform Data > From Text/CSV. I was able to do it using the traditional way, in which I was able to select/adjust specific columns. Here is a screenshot provided:

 

Guillermo49_0-1597669442673.png

But when I got to Data >  Get & Transform Data > From Text/CSV, I cannot seem to select/adjust specific columns.

 
 
 

s1.PNG

 

Please help me on this.

 

Thanks.

 
 

 

 

3 Replies
If you change the numbers in the box that currently contains 0, 82,133, 260, 315, can't you get it to do what you want?
Hi Jan,

Unfortunately, it doesn't work. Please, see how to work the import wizard in Excel 2010, 2013, etc. in these section. I think it must be a kind of error or something wrong because before it worked very well.

Regards,
Guillermo.

@Guillermo49 

In general it shall work.

If after changing the numbers you click on Refresh icon, numbers will be returned in initial one. However, if instead to click on any empty cell in preview window, new numbers will be taken to show how the text is split.

Alternatively you may Transform and correct numbers in formula bar.