Calc: wildcard use to intercept a string

users
#1

Try:
=NOT(ISERROR(FIND("XYZ";A1)))
This will give TRUE if XYZ is found and FALSE if not. If you format those as numbers, they will appear as 1 and 0 respectively.

I trust this helps.

Brian Barker