NEED TO CONVERT A WORD ADDRESS LIST TO EXCELL

[Guest]

I help with a food pantry and the existing cliant data list was created in
word seperated by commas. I am told to put all 1500 or so cliants in to note
pad, then put them on one line (data of each cliant seporated by 7 commas and
their children seporated by then I can put them into excell. Well I am
only up to the C's and have been doing it for 3 weeks now. Plus we keep
adding new ones every week which are not in order now.

If anyone could help me with this I would so appreciate it.
Thank you
Beverly

 

[Shauna Kelly]

Hi Beverly

In Word, click the ¶ button on the toolbar. That displays a ¶ sign at the
end of every paragraph. Does your Word document look something like this:

Fred Smith, 123 George Street, Somewhere¶
Anne Jones, 123 Station Street, Somewhere Else¶

That is, each client has one paragraph, and the fields of information (in
this case only name, street and town) are separated by commas. If that's the
case, then I would proceed as follows:

1. In Word, open up the file. File > Save As. In the "Save as type" box,
choose "Plain text". Give your file a name, and click Save.

2. In Excel, File > Open. In the "Files of type" box, choose All Files.
Locate your file and click Open.

3. You should now see Excel's Text Import Wizrard.

3a At the first step, choose Delimited (not Fixed Width). Then click Next.

3b At the second step, in the Delimiters section, tick Comma and un-tick
everything else. You'll see the Data Preview at the bottom of the screen is
showing you what the result will be like. Looking good? Click Next.

3c. At the third step, you can specify that some columns are dates or
numbers. If you have date fields in your data, click the appropriate column
and choose Date. When you're finished, click Finish.

4. You should now have an Excel file with each client on one row, and each
field in its own column. You will probably have to widen the columns to see
all the information. Save the Excel file.

5. Ring up the person who told you about Notepad and all the commas. Tell
them you're working hard on it, but you have about 23 more weeks to go (at
one week per letter). Take a long holiday, and them send them the Excel file
in about September.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Volunteer for food pantry" <Volunteer for food
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Graham Mayor]

If you have a comma delimited file, i.e. each record is on a single line
with each field separated by commas, then you can simply import this into
Excel directly. If it is in some other format, there must be an easier way
than manually and I can't see Notepad helping much. Word is far more
powerful - have a look at
http://www.gmayor.com/convert_labels_into_mail_merge.htm and see if any of
those stages looks familiar.

If this doesn't help and you can send me a sample via the link of my web
site, I'll have a look at what's involved.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>