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

Compare texts in Excel 2003
 

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

"K" wrote:

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

Compare texts in Excel 2003
 

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



"roadkill" wrote:

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

"K" wrote:

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