Text to columns - unusual requirement

%3CLINGO-SUB%20id%3D%22lingo-sub-1639943%22%20slang%3D%22en-US%22%3EText%20to%20columns%20-%20unusual%20requirement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639943%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20get%20a%20txt%20file%20each%20day.%20When%20I%20open%20it%20in%20excel%20depending%20on%20the%20data%20that%20comes%20through%2C%20using%20the%20wizard%20sometimes%20puts%20breaks%20in%20different%20places.%20I%20want%20excel%20to%20put%20a%20column%20break%20in%20the%20same%20place%20each%20time%20irrespective%20if%20there%20is%20a%20space%20there%20or%20not.%20How%20do%20I%20get%20excel%20to%20always%20put%20a%20break%20at%20position%202%2C%2015%2C%2034%2C35%2C64%20etc%20each%20time%20I%20import%20the%20daily%20txt%20file%20without%20me%20having%20to%20click%20each%20of%20those%20spots%20as%20there%20are%20about%2075%20of%20them.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I get a txt file each day. When I open it in excel depending on the data that comes through, using the wizard sometimes puts breaks in different places. I want excel to put a column break in the same place each time irrespective if there is a space there or not. How do I get excel to always put a break at position 2, 15, 34,35,64 etc each time I import the daily txt file without me having to click each of those spots as there are about 75 of them.

Thanks 

1 Reply

Hello @Leigh63

Sorry to disappoint you but this is the Microsoft Learn community and is not exactly specialized on your topic/question. Although one or the other MCT specialized in this technology could be visiting this community I have the feeling that your question should be posted in the respective community.
Thank you for your understanding. Here is the link to the community:
https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat
Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42