If function

[Veronica]

In cell A1 I have: action, fiction, drama
If I have the word "drama" in cell A1, I want to enter the word "drama" in
cell A2.
How can I do this? I tried to use the if function but it doesn't work
because the words "action" and "fiction" are on the cell.

 

[Steve R]

=if(A1="drama","drama","")

 

[Roger H.]

Hello Veronica. As a follow up to the previous answer, you might need to put
an asterisk in front of the first argument to the if finction to account for
the preceeding text : =IF(A1=*"drama","drama",""). This lets the function
know that there's other text within the cell, that comes BEFORE the text
"drama".

 

[Roger H.]

Oooops......put the asterisk WITHIN the quotation marks--- sorry.