Headers in Excel

Question

Headers in Excel

Anupam Shrivastava (Nokia) 0

Dear Experts, In notepad++, I have data headers as these: User's image

and want to export it to excel, but seems they are not aligned as below

User's image

I am attaching the txt file notepad++ , seems attaching excel not supported.

Thanks & Regards

[Moderator note: personal information removed]

headers.txt

0 comments

1 answer

Your answer

Answer 1

Hendrix-C 17,580 Microsoft External Staff Moderator

Hi @Anupam Shrivastava (Nokia),

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, the reason the TBinfo is not aligned with the numerology column is that in your notepad, the TBinfo is placed on the second pipes |, which means it's placed on column 2 when numerology is placed on fifth columns. Even if the interface in your notepad showing they're aligned, Excel places them based on the delimiter |. That's why it places TBinfo on second column as you set in your notepad. To make them align, you just need to add three more | in your notepad and then try importing the data again. Excel will now put the TBinfo correctly align with the numerology.

User's image

I hope this helps you move forward smoothly. If you have more questions or need further clarification, feel free to leave a comment here and I’ll be happy to continue supporting you.

Thank you for your patience and understanding, and I look forward to assisting you further.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Anupam Shrivastava (Nokia) 0 Reputation points

2026-01-14T14:55:34.78+00:00

Hi @Hendrix-C , Thanks for your comments, but this is not dynamic, if you go right in the notepad++ I shared, we have something like this

I can share my logic-> So, each row has a diff number of "|", what I did is count the number of "|" in each row and then find the one with max num of "|", then substituted each row with that max num of "|", but it didn't helped..

Could you please export this header in a excel with your logic and share.

Thanks in Advance,

Br,

Anupam
Hendrix-C 17,580 Reputation points Microsoft External Staff Moderator

2026-01-14T19:22:00.6033333+00:00
Hi @Anupam Shrivastava (Nokia),

This is the steps I did to import your headers inside my Excel:

Open a blank Excel worksheet then paste the whole data into cell A1

Then I select the column A > go to Data > Text to columns > Delimited > only select Other: | > Next > Finish

This is the result of the notepad text in my Excel file:

Is this your expected outcome? If not, please share me more details about what you expected when pasting the text into Excel sheet so I can clearly understand and provide you the most appropriate guidance.

Thank you for your patience and understanding. Looking forward to your response
Hendrix-C 17,580 Reputation points Microsoft External Staff Moderator

2026-01-18T23:26:45.7966667+00:00

Hi @Anupam Shrivastava (Nokia),

I hope you are having a great day.

I'm reaching out again to follow up on your issue and check if everything has been resolved. My goal is to ensure your experience remains smooth and hassle-free. If you're still encountering any problems or have run into new challenges, please let me know which steps you're currently stuck on and happy to provide further help whenever you need it.

If you have any further questions, feel free to tag me in your reply so I can assist you directly.

Looking forward to your update.

Share via

Headers in Excel

1 answer

Your answer