I need to identify cells with postal codes starting with K1... or K0...
I tried this formula: =IF(OR(N2="K1*",N2="K0*"),"ADD","")
So i am trying to use * as a wildcard but i'm not getting results.
Tried also with ~ and ? as wildcards... no success.

Postal codes are K1C 2B7 for example... i need to identify all the postal codes in a row that start with either K1... or K0...
I even tried ex: N2="K1?????"... no use.

Any help would be greatly appreciated!!