Creating a separate column from another column based on "if contain the word"

[pedexe90]

I have a range of vertical data in one column from E1:E1406 with cells containing 5-6 letters. I want to create a separate column next to it which would extract cells from E1:E1406 containing a certain word, in this case the word "FT" and populate the separate column automatically.

I tried Vlookup but that only finds the first cell containing the FT.

Thanks for your help in advance.

 

[cerfani]

=IF(SEARCH("FT",E1),E1,"")

maybe that?

 

[pedexe90]

Many thanks for your reply.

I tried that but it did not work. The issue is that I am looking for smarter way to do this. I believe using the search formula would leave the unmatched cells empty. I simply want words with letters "FT" to be repopulated from one column to another column without any gaps between them (or empty cells. I think there is [FONT=Lato, sans-serif]SMALL(IF()) formula that can be used or an index formula which could look up all the cells in one column and create another cell containing the matched letters.

[/FONT]Many thanks