Forum Discussion

Leigh63's avatar
Leigh63
Copper Contributor
Sep 07, 2020

Text to columns - unusual requirement

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

  • Rolf-42's avatar
    Rolf-42
    Iron Contributor
    Sep 08, 2020

    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 

Resources