Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge different first name, same last name, same address
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge different first name, same last name, same address
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: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=500455 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge different first name, same last name, same address
No, each entry is in a different cell, including first name, last name,
street number, street name. "LACA" wrote: 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: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=500455 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge address in XL to Word letter template | Excel Discussion (Misc queries) | |||
Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
Separate address column to Five columns | Excel Worksheet Functions | |||
Mail Merge creates a space in the address block | Excel Discussion (Misc queries) | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel |