I'm having trouble getting the "*" wildcard to work in my IF statement.


Here's a simple example of my formula that resides in {Column B}:

=IF(A2="*McCaleb",TRUE,FALSE)

Here's my array:
{Column A} {Column B}
Justin McCaleb FALSE
Daniel McCaleb FALSE
Tori McCaleb FALSE
Jeff McCaleb FALSE
Renee McCaleb FALSE
Chuck Lodge FALSE
Marlene Lodge FALSE
Mom Durst FALSE
Jim Durst FALSE
Bruce Smith FALSE
Lynda Smith FALSE
Shouldn't this return a "TRUE" in any cell that contains "McCaleb"?