=EQUIV(" ";STXT(A1;NBCAR(A1)+1-LIGNE(INDIRECT("1:"&NBCAR(A1)));1);0)
=NBCAR(STXT(A1;TROUVE("|";SUBSTITUE(A1;" ";"|";NBCAR(A1)-NBCAR(SUBSTITUE(A1;" ";))));5^5))
NBCAR(A1)-CHERCHE("µ";SUBSTITUE(A1;" ";"µ";NBCAR(A1)-NBCAR(SUBSTITUE(A1;" ";""))))
NBCAR(A1)-CHERCHE(" ";A1)
=NBCAR(A1)+1-TROUVE("µ";SUBSTITUE(A1;" ";"µ";NBCAR(A1)-NBCAR(SUBSTITUE(A1;" ";))))
=EQUIV(" ";STXT(A1;NBCAR(A1)-LIGNE($1:$255);1);0)
Bonjour à tous,
@ CISCO : il me semble que tu as oublié un +1 non ?
A+