Hello,

I have an Excel application where I read a text file.Recently the text
file had a change and had three(3) new fields added.This data is now
in the last column.I want to parse this data which has a space
delimiter into three seperate columns.There are 10 fields and the data
is captured  in the last column.How do I do this in VBA without the
"text to column" manual method.

Thanks,
Roy