| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Duplicate data row wise from each cell
I have a big file and I want to delete duplicate data in rows
separated by comma in same cell i.e Sample File COL A Pepsi Cola, Coke, Pepsi Cola, Toyota Mercedes, M700, Toyota, Tom, Peter, Coke Pepsi Cola Pepsi Cola, Coke, Coke Tom, Peter, Mike, Don, Paul, Tom, Mike Pepsi Cola, Coke, Pepsi Cola, Toyota Mercedes, Toyota M700, M700 There are like 10,000 rows like this ..... ... Required File Pepsi Cola, Coke, Toyota Mercedes, M700, Toyota, Tom, Peter Pepsi Cola Pepsi Cola, Coke Tom, Peter, Mike, Don, Paul Pepsi Cola, Coke, Toyota Mercedes M700 There are like 10,000 rows like this ..... ... Required: We just want to delete the duplicate data ROW WISE from same cell Any solution will be appreciated Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete duplicate data in a single cell | Excel Worksheet Functions | |||
| delete duplicate data in the same cell | Excel Programming | |||
| How to delete duplicate data | New Users to Excel | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
| Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
Threaded Mode
