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.
--
David Biddulph

"Kam" wrote in message
...
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.