Posted to microsoft.public.excel.misc

Jeff[_4_]

external usenet poster

Posts: 23

How to import text file into one column

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
import from text file	jason2444	Excel Discussion (Misc queries)	2	January 17th 07 04:22 PM
Would Like to Automate Batch File Creation and Text FIle Import	socrtwo	Excel Discussion (Misc queries)	2	August 18th 06 03:54 PM
text import all in one column. how do I set it to multiple column	maggie Hettinger	New Users to Excel	2	April 10th 06 04:49 PM
Specifying Row / Column in Import File	Data Gladiator	Excel Discussion (Misc queries)	2	January 6th 06 03:38 PM
import data from a text file	jonny365	Excel Discussion (Misc queries)	0	September 6th 05 03:42 PM

All times are GMT +1. The time now is 08:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us