I'm not sure my coding would help (its that bad),

Basically data in
Column 2 is: 123......ABC;
Column 4 is: XYZ;

Both columns declaired as strings,

I want to take the ABC out of column 2 anc concatinate the XYZ on the end.

Previously if I wanted data input from column 2 it would be using

.Answer = strline(2)
Which would input everything in the column, but this time I want to only include from char 10
And I would repeat this in a loop of +1 till the end of file

Or if I wanted to read data from a string starting at a certain place it would be

.Answer = Mid(sLine, 15, 3) 'Assuming the XYZ started at the 15th character
And again repeat till end of file.

Looking to mix it so this time:

.Answer = Trim(strline(2), sline, 10) & " " & Trim(strline(4)) 'Assuming XYZ is in column 4

And again loop with +1 till end of file.

Does that make sense or have I made things worse???

Thanks