View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ali Ali is offline
external usenet poster
 
Posts: 80
Default Check if cells contain the word "Thailand", return "TRUE"

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