How can I find a part of a text string in a cell from an external file?
This is what I currently have but it wont let me use wildcards (e.g.
"*ages*").

{=COUNT(IF('C:\[fileA.xls]sheetA'!$M$4:$M$1000="ages",'C:\[fileA.xls]sheetA'!$L$4:$L$1000))}