View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default How to import text file into one column

Hello,

When you import, choose "Fixed Width" and remove all the lines, it
should place all the data in one column. Also, I've literally cut and
pasted text from Word into Excel and it ended up in one column.

HTH,
JP

On Oct 19, 5:32 pm, "Jeff" wrote:
Hi

I'm using Excel 2002 and need to do the following:

I have a text file in Word consisting of words each separated just by a
space. I need to get these words into Excel such that each word fits
into one line within the same column. I've tried import and variety of
fills and cannot do it.

Could someone explain to a novice how to do this?

Thank you.

Jeff