| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible text-to-columns bug
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Threaded Mode
