Close, but backwards, and you have to decide what to do when there is NO
match which will result in an error, not an asnwer of zero. Like this:

=IF(ISNUMBER(SEARCH(B2&"*",A2)),"Found","Not Found")

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"trinatoa" wrote:

using excel 2003. i wish to identify the when text from one cell is repeated
in another cell
A2 Mrs Brown, 1 sample road, blurb city.
B2 1 sample road
C2 (contains my function to return a value)

i've tried to used search with a wildcard but it's not working
=search(A2*,B2) help says you can use wildcards but it doesn't give an
example so i guessed. can anyone help?