How convert text file into excel

[Guest]

I have one huge text file which I need to convert to excel. I know about the
"Text to column" in excel but ti not giving me right output. Can you please
advise is there any VB script or macro that you can prepare.

Appreciate your kind assistance.

Kam.

 

[David Biddulph]

The important parts of your message appear to have been lost, such as:
What did your data look like, what options did you use in "text to columns",
what output did you get, and what output did you expect?

Even the experts in the group will struggle to guess the answer if they have
to guess the question as well.