hi,
have you tried datatext to columns? Its a built in wizard.

Regards
FSt1

"Naraine Ramkirath" wrote:

Hi All,

On a monthly basis I import a text file into excel and "massage" the data to
fit into the columns. However, this is a long and tedious process. I am
wondering if some one could provide a vb script that will do this for me.

Any help would be greatly appreciated.

Regards,

Naraine