Thread: Compare two columns of texts in Excel 2003
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
K K is offline
external usenet poster
  
Posts: 108
Default Compare two columns of texts in Excel 2003
thank you again.

K


"Gary''s Student" wrote:

=IF(LEN(B1)=LEN(SUBSTITUTE(B1,A1,"")),"no match","match")
--
Gary''s Student - gsnu200904
Reply With QuoteReply With Quote