Address label help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lost printer - 20 Dec 2005 06:18 GMT

I am new to excel and I have a client that has a mailing list that wa
scanned and now in a word doc with 3 or 4 lines. ie
Name
Address
Address 2
City state zip

with nothing breaking the City state zip but a space. how can I conver
this to an excell file with 7 fields ( Last name, first name....) ?

Los

Reply to this Message

Stefi - 20 Dec 2005 08:09 GMT

Have a look at Data/Text to columns, it is almost self-explanatory!

Regards,
Stefi

„lost printer” ezt írta:

> I am new to excel and I have a client that has a mailing list that was
> scanned and now in a word doc with 3 or 4 lines. ie
[quoted text clipped - 7 lines]
>
> Lost

Reply to this Message

David McRitchie - 20 Dec 2005 23:36 GMT

Text to columns will not help you, that is to separate items
on the same line.

Possibly you do something in MS Word with what you have,
but I only can suggest a solution of pasting your data
into Excel then doing the following.

To prepare the data if it is in Excel you have see
http://www.mvps.org/dmcritchie/excel/snakecols.htm

then for help if needed with Mail Merge see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm#snkAddr

and at the bottom of that section are links to two macros
use the NAddr3SS macro and reply with 0 since you have a blank
line between sets. If the data does not come into Excel as
you indicated with then there are other solutions on the page as well.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I am new to excel and I have a client that has a mailing list that was
> scanned and now in a word doc with 3 or 4 lines. ie
[quoted text clipped - 7 lines]
>
> Lost

Reply to this Message

zahoulik - 21 Dec 2005 23:47 GMT

If your list of addresses isn't too long, I'd just do it the old
fashioned way: cut and paste. It may be more tedious, but easier to
understand.

Z

Signature

zahoulik

Reply to this Message

lost printer - 22 Dec 2005 00:51 GMT

I have 4300 names and addresses cut and past is no go

Signature

lost printer

Reply to this Message

cycling-rod - 22 Dec 2005 12:15 GMT

On a copy, so as to keep the original safe, I would use Find and Replac
to put a comma in to every space. This CSV file (comma separated value
could then be merged onto an excel sheet. See CSV here
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm Depending on th
fields used along Row 1, you could merge all first names in to th
first column, the last names in to the second column, and so on. With
little trial and error, most names and address will line up correctly
with (hopefully) only the odd ones that need to be changed manually.
I've done this to a similar files as yours and with a bit of patienc
it is possible to do. If things do go wrong, you will still have th
original in a safe place

--
cycling-ro

Reply to this Message

David McRitchie - 03 Jan 2006 21:41 GMT

No the data is on separate rows.
The poster needs to use a macro, if not a macro there
are still other solutions there using worksheet formula, from
another worksheet and dependent on there being no
exceptions to how many rows per addressee.
(see what I posted befored).

When finished separating the City ST zip
is trivial if the State is a two character state code
http://www.mvps.org/dmcritchie/excel/join.htm#seplastterm
Otherwise you may have to make changes first to
combine words in states that begin with New, North,
South by including a period after, separating and then
removing the period.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> On a copy, so as to keep the original safe, I would use Find and Replace
> to put a comma in to every space. This CSV file (comma separated value)
[quoted text clipped - 7 lines]
> it is possible to do. If things do go wrong, you will still have the
> original in a safe place.

Reply to this Message