MERGING CELLS WITHIN XL

[BRANDI]

EXCEL, IT'S THE FORMATTING THAT I AM STUCK ON. THE COLUMN
IS LIKE THIS:

111 11TH PLACE NORTH CELL A3
BIRMINGHAM, AL 11111 CELL A4
1256 11TH PLACE S CELL A5
BIRMINGHAM, AL 12345 CELL A6
4589 11TH PLACE NORTH CELL A7
BIRMINGHAM, AL 54321 CELL A8

NOW WHEN I MERGE MY CELLS, MY LABELS TURN OUT WITH JUST
THE STREET ADDRESS ON ONE LABEL AND THEN THE CITY AND
STATE ARE ON THE NEXT LABEL. HOW DO I MERGE CELLS A3 AND
A4(FOR EXAMPLE).

 

[Dave Peterson]

You'll want to put all the data for each label on one row. (It'll make your
life much easier.)

In B3 put this formula:
=IF(MOD(ROW(),2)=1,A4,"deleteme")
(and copy down)

then copy|Paste special|values to convert to values.

Apply data|filter|autofilter to column B and filter to show "deleteme"

Then delete those visible rows.

Now try your mailmerge again.

And a couple of links that may help (yeah, you didn't ask!):

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

 

[Dave Peterson]

ps. You have another response at your other post, too.