A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.