On Sep 10, 1:26 pm, ali wrote:
Big thanks to all you guys, but i've already figured it out.

i just use " =ISERROR(SEARCH("thailand",A2,1))" , so i'll get "TRUE" and
"FALSE", and then i just re-sort them again and i'll get those entreis
containing "THAILAND"

thank you guys all anyway, ^_^!!!
--
Allen Phailat Wongakanit



"ali" wrote:
I have a spread sheet (5000 entries)

i have an extra column at the end.

I'd like to generate a formula which find if my data in column A (A1:A5000)
contans the word "Thailand".

if it containt the word "Thailand" , i shall get a sign (or an indicator,
say... "TURE", something like that)

--
Allen Phailat Wongakanit- Hide quoted text -

- Show quoted text -

please view www.thaitreasuretrove for information on thailand and join
the forums to enjoy disscussions.

Stephen