=SI(NBCAR($A1)-NBCAR(SUBSTITUE($A1;" ";""))<=COLONNE();
STXT($A1;1;TROUVE(" ";A1)-1))
[COLOR=blue]=SI((NBCAR($A1)-NBCAR(SUBSTITUE($A1;" ";"")))>=COLONNE()-2;[/COLOR]
[COLOR=blue]STXT($A1;TROUVE("µ";SUBSTITUE($A1;" ";"µ";COLONNE()-2))+1;[/COLOR]
[COLOR=blue]TROUVE("µ";SUBSTITUE($A1;" ";"µ";COLONNE()-1))-TROUVE("µ";SUBSTITUE($A1;" ";"µ";[/COLOR]
[COLOR=blue]COLONNE()-2)));"")[/COLOR]
[COLOR=blue]=SUPPRESPACE(SI(EXACT(B1;MAJUSCULE(B1));B1;"")&" "&[/COLOR]
[COLOR=blue]SI(EXACT(C1;MAJUSCULE(C1));C1;"")&" "&[/COLOR][COLOR=blue]SI(EXACT(D1;MAJUSCULE(D1));D1;"")&" "&[/COLOR]
[COLOR=blue]SI(EXACT(E1;MAJUSCULE(E1));E1;"")&" "&[/COLOR][COLOR=blue]SI(EXACT(F1;MAJUSCULE(F1));F1;"")&" "&[/COLOR]
[COLOR=blue]SI(EXACT(G1;MAJUSCULE(G1));G1;""))[/COLOR]