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