Frans Scheepers
Board Regular
- Joined
- Apr 21, 2006
- Messages
- 127
Hi There
This might be a stupid one but it has me baffeld. Why is it that when you do a text to column convertion it so happens that when you paste another set of data in the same workbook that it is automatically delimited.
I found that when I delimit a set of data using : as the delimiter and the paste another set of data that also contains : it is delimited automatically by excel.
This is anoying because I have to close Excel down after each delimit action I do to stop it from delimiting automatically.
Is there a way of stopping it from doing this?
This might be a stupid one but it has me baffeld. Why is it that when you do a text to column convertion it so happens that when you paste another set of data in the same workbook that it is automatically delimited.
I found that when I delimit a set of data using : as the delimiter and the paste another set of data that also contains : it is delimited automatically by excel.
This is anoying because I have to close Excel down after each delimit action I do to stop it from delimiting automatically.
Is there a way of stopping it from doing this?