I'd start by recording a macro when I did it manually.

wrote:

Hello All,
I am new to the world of macro, and need some help/advise ..
I am trying to copy contents of a csv/text document into a excel
worksheet and remove some of the unwanted fields in the process and
paste the data in the right columns... (format the data)

Is there a way this can be achieved automatically ...

any help/advice/pointers will be greatly appreciated

thx

--

Dave Peterson