If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: VBA Table manipulation

Hi Group,
I've used a import specification to import a Fixed-width file. However because of the layout of the initial file, i.e the fields' header starts BEFORE the fields data, I need to do some manipulation to get rid of the extra space in each row.

How can I loop through each record of the table to get rid of this extra space. Is there a a special character I can use for a space?