copying text into XL & text to columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 26 Jul 2007 14:39 GMT

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

Reply to this Message

Peo Sjoblom - 26 Jul 2007 15:54 GMT

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?

Signature

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 9 lines]
>
> Any help greatly appreciated.......Regards, Jason

Reply to this Message

Dave Peterson - 26 Jul 2007 17:37 GMT

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

> Hi,
>
[quoted text clipped - 9 lines]
>
> Any help greatly appreciated.......Regards, Jason

Signature

Dave Peterson

Reply to this Message