copying text into XL & text to columns

[Jay]

Hi,

I have a large text file that I'm wanting to convert to a table. I was
hoping to simply paste it into Excel & then split the fields using Text to
Columns. The problem I'm having is - when I paste the data in, instead of
putting it all into one column (thus allowing me to use Text to Columns), it
pastes it across 9 columns, with no actual logic to how the fields have been
delimited compared to the original file.

Is there any way I can force it to paste how I need it - into just one
column.

Any help greatly appreciated.......Regards, Jason

 

[Peo Sjoblom]

Have you tried to open it directly without pasting, that way the text import
wizard will start (same as text to columns) or is it too big?

 

[Dave Peterson]

Excel likes to help.

If you've run data|text to columns in that session of excel, then excel will use
those settings when you paste.

You can close excel and reopen it so that excel forgets about those settings.

Or you can do a dummy data|text to columns
select an empty cell
type "asdf" into that cell
data|text to columns
delimited, but uncheck all the options
finish up
clean up that cell