Can you post the text file at this website. Open the text file with
notebook. sometimes it is easier to make the conversions on the text file
instead doing it on the worksheet.

I like converting the text files to CVS files and then reading them into
excel.

"Parusky" wrote:

Please help. VBA Ignorant. I am trying to build a macro to convert a lot of
fixed width data from text to columns sequentially for multiple rows. The
macro recorder will not work due its nature with arrays. The simple keyboard
commands that do work are as follows:
Alt D
Alt e
Enter
Enter
Enter
Arrow down
Got the books on VBA but can't seem to get started on this simple repetitive
onerous manual task. A keyboard recorder would be nice.

Thanks for your kind assistance

Parusky