Gerald,

Is the data separated by spaces, tabs, etc?
How is the data separated?

Text-to-Columns allows you to choose one or more of these, and others.
Including one of your own choosing...

The trick is knowing what separates one data byte from the next...

Reply back...

--
steveB

Remove "AYN" from email to respond
"Gerald" wrote in message
oups.com...
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!