Is it possible to write a macro to convert data? I currently use the
text import wizard but since the file I am importing is not delimited
so I choose fixed width and adjust the columns according to the
heading. The problem is some fields in the data are actually longer
than the heading for that column and thus the contents get spread over
two to three columns. Any help in writting a macro for this, if
possible, would be appreciated.

Thanks!