cemil is right. When pasting (in MS Excel) a "paste options" tab appears. Your options are Match Destination Formatting and Use Text Import Wizard. Choose the latter. A window appears, click the "fixed width" radio button; in the next window, the data is automatically in the correct columns, just click next. A pain in the bum. Edit: Just read your next post! Forget the above. Before pasting, set the cell type to "Text". Then 17 Aug 07 will paste into one column. Excel parses what you try to paste in according to the cell type.
Last edited by INFIDEL
on August 19th, 2007, 10:00 pm, edited 1 time in total.