I am trying to write a formula that will use the wildcard character with the
NOT function. In a list of names, I need to know which names were written as
First Name Last Name and which names were written Last Name, First Name. The
following formula works if you know the specific name.....=NOT(A2="Jones,
Jim")....but not if you have names other than Jones, Jim.