Text to Columns (easy ?)

[keeswijn]

When I open a new workbook and paste data from a text file, I have to convert the text to columns....OK so far
When I then try to paste data from a text file to the second sheet, Excell seems to do the text to columns conversion automatically but using incorrect breaks. Anyone know how I can turn the automatic conversion off ?.

TIA...Kees

[Jay Petrulis]

In your original file import, did you change the default delimiter setting? If so, the second import is probably still using that changed setting.

When (if) the wizard appears on the second import, go through the all steps again rather than hitting finish (which I usually do and then have to redo).

Bye,
Jay

[Chris Davison]

I get this all the time aswell.

if Jay's suggestion doesn't help (highly unlikely)

try this code

Sub ClearClipboard()
Application.CopyObjectsWithCells = False
Application.CutCopyMode = False
End Sub

(pasted from one of Brett's earlier postings about the clipboard, I'm sure he recognises his code!)

or shut excel down and reload it