Lets say I have few companies and each of company can have 100s different
products. Products are defined as string and string can be a combinations of
text and numbers (acme5), special characters (Acme_100, acme.tools) What is
the best function to find customer? I tried =IF(A1="acm*","Acme",0), but
returned value is always false. What is the best way, function to select
specific customer? I dont want to count them, I want to assign customer
name to each customer. Thank you.