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
|