Hi:
I have a list:
Ted Jones
Jones,Ted
In B12, I want to return "" for all values containing "," if not return cell value.
So if cell value is Ted Jones, return Ted Jones.
If cell value is Jones,Ted, return ""
Formula below is returning cell value even if condition is met...