How do I use the wildcard character and the NOT function?
 

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.

=IF(ISERROR(FIND(",",A2)),"First Last","Last, First")

Though it will choke on Jim Jones, Jr.

HTH,
Bernie
MS Excel MVP


"KDA" wrote in message
...
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.