Doesn't wildcard work anymore?

[Sean15]

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.

=IF(B12="*,*","",B12)

Could you advise please?


Regards,

Sean

 

[shaowu459]

=if(isnumber(find(",",b12)),"",b12)

 

[Sean15]

Thank you very much.

Regards,

Sean

 

[MARK858]

IF you really wanted to do it with a wildcard then you could do....

Excel Workbook
	B	C	D	E
12	Ted Jones			Ted Jones
13	Jones,Ted
Sheet1

 

[Sean15]

yes, thank you.


Regards,

Sean