I've noticed that, when using the text-to-columns function in Excel 2007,
that if the delimiters are changed to text and space, these are then retained
as defaults for all sorts of text imports. In particular, when trying to open
a csv file or paste from another application. The only way I've found to
correct it is to carry out another text-to columns split on a cell with a
single word and change the delimiter back to Tab.
Anyone else experienced this or know why it's happening?