View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Match similar names

This might work for you...Try the below formula in cell C1...

=IF(ISNUMBER(SEARCH(B1,A1)),"Probable Match","No match")

--
Jacob


"Sam" wrote:

A1 B1
Frank Mark Allen Frank Mark Allen Frank Mark

I want to compare two cells. A1 contain full name , B1 contain short name .
searching for formula to do a minimum match.