Text to columns - unusual requirement

Copper Contributor

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