I would like to request Experts help create a macro to copy data from .TXT file into Excel sheet automatically. I have attached the sample .TXT data that I would like to copy into the Excel sheet. The data need to be copied from Column A to Column F evenly so that the data from .TXT were not missed out. I have almost 500,000 data need to copy from .TXT file into this Excel sheet. I have manually copied few data at Excel sheet for Experts to get better view. Hope Experts will help me to create this feature.