That could actually be very difficult, depending on what font you use in Notepad.exe. Some fonts are variable width so that the letter M is a lot wider then the letter I. If you use a fixed-width font then your problem becomes a lot easier, just count the number of characters up to the column you want.
A few things:-
Are you using spaces in the file as a column separator ?, if yes then you shouldn't go with this because it will not do any meaningful.
lets see ex:-
(text1.text="Any string") and Next time it may be(text1.text="Entire Line with group of strings") then it will write to file as:-
Entire Line with group of strings
as you put one space as separator, so here you cant identify(for further uses) that what is next(text3.text) because the second line has a lot spaces.
Space function takes so much time
if it takes really then you should go with vbTab
at last you should use something different character as a column separator rather than using space .