Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Manipulation
An Excel Spreadsheet is set up like this with hundreds of duplicate names and
addresses: Name Address City Zip Etc. Smith, Joe 10 S. Oak Smith, Mary 10 S. Oak QUESTIONS: 1: How do I eliminate the comma and everything to the right of the comma for all records, i.e. ,Joe and , Mary. 2: How do I eliminate duplicate addresses. My goal is to have one entry as follows: Name Address Smith 10 S. Oak And eliminate duplicate addresses and first name leaving only one last name to each address. Can it be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Manipulation - Excel 2000 | Excel Discussion (Misc queries) | |||
Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function | Excel Worksheet Functions | |||
Complex calculation and manipulation in Excel | New Users to Excel | |||
Excel Worksheet manipulation | Excel Discussion (Misc queries) | |||
Excel Time Manipulation | Excel Discussion (Misc queries) |