By the way, sometimes these type problems are easier to solve if you
let the macro open the text file. For example in you spreadsheet you
had the word Department split into columns B and C. I can open a text
file in VBA and get the word department to be in one column in stead of
tow columns.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=191856

http://www.thecodecage.com/forumz