View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Claudio P.
 
Posts: n/a
Default problem in finding words into cells of a column

My formula can find only the word cremona into from cell D2 to cell
D100.
can you help me please ?

--------------CUTHERE----------------
=IF(FIND("cremona";D2)0;"Cremona";IF(FIND("spatoc co";D2)0;"spatocco";IF(FIND("magliano";D2)0;"mag liano";IF(FIND("desenzano";D2)0;"desenzano";IF(FI ND("aosta";D2)0;"aosta";IF(FIND("ascoli";D2)0;"a scoli";IF(FIND("amandola";D2)0;"amandola";""))))) ))
--------------CUTHERE----------------

thank you very much

Claudio