Hi,

I have a program that extracts variable names from text that I paste into excel from various .txt files. The macro works fine, but I am noticing that certain text that ends with [ "] is not being pasted into excel correctly. For instance, the following lines do not paste correctly into excel.

748 13: D7G.rcad5 "Hat 4 Box: xxxxxx x2 "
749 13: D7G.rcad6 "Hat 4 Box: xxxx 2 xxx "
750 13: D7G.rcad7 "Hat 4 Box: xxxxxxxx xxx "

It seems to have something to do with the tab" at the end of the line (If I delete the tab everything pastes OK into excel). Are there settings in excel I can change so that this pastes accurately?