View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K K is offline
external usenet poster
 
Posts: 108
Default Compare texts in Excel 2003

if I have "Today is Tuesday" in column A and "Today is Tuesday Today is
Tuesday" in column B. Is it possible to compare column A and B and have a
result like "match" in column C? So kind of like using column A as a phrase
and not looking at each words individually. More examples below.

Column A Column
B Column C
today is monday today is tuesday today is monday
match
today is monday today is friday today is thursday
unmatch

thanks,

K