Importing Text (Word) in to Excel


T

tparrish

I am trying to, without much luck, to import text from Word in to
Excel. I have a list of addresses, names, phone numbers, etc. that I
need to import in to single cells in Excel to use in creating mailing
labels. When I try to import the text it places all the data in to
one cell. Is what I am attemting to due possible? If so, how can I
successfully complete this.

Thank you for your time,

Tom
(e-mail address removed)
 
Ad

Advertisements

E

Erny

Hi Tom,

Try using >Data >External Data >Import Data...

You should be able to specify the file name and decide where to put the
separators for the different columns in Excel.

Good luck and kind regards,
Erny
 
E

Earl Kiosterud

Tom,

Excel can't, to my knowledge, read (File-Open) or import (Get External Data) word files.
You can copy-paste word stuff into Excel. It doesn't, in my experience, put all the stuff
into one cell. How are you attempting to put the data in Excel? Which version of Excel are
you using?
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
K

Kate G.

How is your information organized in Word? In columns (using TAB)? In a
table? Separated by commas?

Knowing that would be helpful.
 
T

tparrish

How is your information organized in Word? In columns (using TAB)? In a
table? Separated by commas?

Knowing that would be helpful.

--
K.athryn Groves








- Show quoted text -

Kathryn,

Here is a sample of the text I am attempting to import in to Excel
(different cells for name, address, etc.)

DIANNA RODRIGUEZ BOYD ELEMENTARY SCHOOL 11TH AND HUNT AVENUES ALAMOSA
81101

The text is in a single line, no table, no punctuation between info.

Thanks for your quick and kind reply,

Tom
 
H

Harlan Grove

tparrish said:
Here is a sample of the text I am attempting to import in to Excel
(different cells for name, address, etc.)

DIANNA RODRIGUEZ BOYD ELEMENTARY SCHOOL 11TH AND HUNT
AVENUES ALAMOSA 81101

The text is in a single line, no table, no punctuation between info.

If there aren't even tabs between different chunks of data, e.g.,
between RODRIGUEZ and BOYD, then you have a manual text processing
task. Excel isn't smart enough to be able to split this into fields.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top