software

I have 3291 names and addresses. In order to avoid creating duplicate
labels, I want to merge rows that have the same last name and street address
but different first names.

Fr:
Jack Smith 123 Elm Street
Jill Smith 123 Elm Street

To:
Jack Jill Smith 123 Elm Street


If the entire name and address is within one cell, you can use the
Data/Text-to-Columns function, and then sort by the address cell.--
LACA
------------------------------------------------------------------------
LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=500455No, each entry is in a different cell, including first name, last name,
street number, street name.

quot;LACAquot; wrote:

gt;
gt; If the entire name and address is within one cell, you can use the
gt; Data/Text-to-Columns function, and then sort by the address cell.
gt;
gt;
gt; --
gt; LACA
gt; ------------------------------------------------------------------------
gt; LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
gt; View this thread: www.excelforum.com/showthread...hreadid=500455
gt;
gt;