in reply to .TXT to Excel

Can you show us several rows of sample input data and a "mock up" of the expected spreadsheet?

In Section Seekers of Perl Wisdom