Please Please - Scan column put information in new column

[jgohearn]

I am very new to openoffice and any help would be greatly appreciated. I think my question is fairly simple, but looking for a solution I got more confused. Right now I have a bunch of information in openoffice calc. In the first column (A) I have a bunch of race titles. example:

Catie Bug for a Cure 5K
32nd Annual Labor Day Run & Kids' Triathlon
Venetian Festival/Jeff Drenth Memorial 10K
Boston Scientific Heart of Summer

I want to be able to scan the whole document and search for any one of these words(triathlon, tri, duathlon) and if it comes across one of those words in column A, I need it to put the capital letter 'T' in the same row of column 'I' If it doesn't find any of the words in a row, just do nothing and skip to the next.

Trying to find the answer in my earlier search had me importing the information to openoffice base, but that just confused me more.

I would really appreciate any help.
Thank You,
John O

[JohnV]

Assuming your first enter is in A1 then in l1 use
=IF(ISNUMBER(FIND("tri";A1));"T";IF(ISNUMBER(FIND("Triathlon";A1));"T";IF(ISNUMBER(FIND("duathlon";A1));"T";"")))

Then drag l1 down the column.

Note that the find text like "tri" is case sensitive. Note also that "tri" would be found it "triple" so you may want to use " tri " to limit to whole words.