Comparing a string to a text file

Originally Posted by KiPA

Oh you are willing to split the text, no problem (I hope).

In that case you could e.g. use a formula like this:

=OR(ISERROR(SEARCH(C1;E1;1))=FALSE;ISERROR(SEARCH(C1;E2;1))=FALSE)

C1 = text to search
E1 and E2 = splitted text where you search from

This applies of course if you can fit your text into two cells. I'm sure you can expand this if needed. Also this returns TRUE instead of number, if the text was found.

What if the text is extremely long and may take up to several dozen cells even when split? I had occasionally needed to use a formula similar to the above but now the files are longer and longer and even merely splitting them manually could take quite some time.

Is there really no way to get it to search an external Word file, or an embedded Word file, or something like that?