Compare texts in Excel 2003

  • Thread starter Thread starter K
  • Start date Start date
K

K

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
 
If A1 had you text to interrogate, B1 had your text that you want to look for
in A1, and C1 was to show the result, you could try something like:

C1 = IF(ISERROR(FIND(B1,A1)),"unmatch","match")

Will
 
Thank you for your help. Is there a good website where I can learn more
information about these kind of functions in Excel?

thanks,

K
 
Back
Top