Excel -if formula - If cell contains jk

[Ebraham]

Hi,


How to write this argument in excel with if or any other formula

if cell contains jk then "jk" otherwise "blank"

 

[konew1]

If your data is in A1
=IF(A1="jk","jk","")

 

[Aladin Akyurek]

In case "contains" is not meant to be "equals to", with A2 as the target cell:

=IF(ISNUMBER(SEARCH("jk",A2)),"jk","")

=IF(COUNTIFS(A2,"*jk*"),"jk","")

 

[Ebraham]

worked weĺl