You could use Conditional Formatting to highlight these cells.

Select your Column
From the Format Menu, choose "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =FIND("MD",SUBSTITUTE(A1,".",""))
Set your format (red background perhaps?)
Click OK

That should do it.

HTH,
Elkar


"Pam Deshazier, SRHS" wrote:

example, in certain column, need to find all records which contain M.D. or MD
or M.D, etc