I like to use VBA or Formula to find exact text string on a cell value Cell Text : JOHN SMITH, JUNIOR, DB JONES , JONES need to find : 1) JOHN SMITH 2) JOHN Could you please help me on this