Parse Text file

[noodle48]

I have coded this so far:

Please Login or Register  to view this content.

Once the file is inputted into the excel sheet it all goes into column A. I want to use vba to separate each column the end results should have column A and B filled. Attach is the file I used to open and wanting to parse.

[Paul]

Hi Noodle,

Try adding this bit of code to the end of your macro (just before End Sub):

Please Login or Register  to view this content.

Hope that helps!

[Leith Ross]

Hello noodle48,

I made a few changes to your code. The fields variable is split using the space delimiter into an 1-D array. This array can then be directly loaded into the cells Ax:Bx in your loop. I have marked the additions in bold text,

Please Login or Register  to view this content.

[noodle48]

Thanks for your inputs but I got the code to work thanks to Paul. That code work great.