Dueling Excel 102


Remove Duplicate Records Based On Partial Text in a Cell

DESCRIPTION

See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using:
1. Formula with SUBSTITUTE, SEARCH, LEFT and COUNTIF, Filter by Value, delete Records
2. Text To Columns and Remove Duplicate Feature

WORKBOOKS