Forum Discussion
Retrun value if cell contains certain text
Hi all,
Hope someone can help me with folowing.
If I have cells in a column, containing the following text: SEAR134A
I want to have a calculated column which give me the folwing outcome:
if the text of a cell in that particular column contains "SEAR", then the outcome must be "REFRIGERANT". If the text in a cell of that particular column does not contain "SEAR", then the outcome must be "OTHER".
Thanks upfront for your kind assistance in this.
John
Anonymous , Try a new column like
Switch(true(),
search("SEAR", [column],,0) >0, "REFRIGERANT",
"OTHER"
)
1 Reply
- amitchandak
Super User
Anonymous , Try a new column like
Switch(true(),
search("SEAR", [column],,0) >0, "REFRIGERANT",
"OTHER"
)