range("b4").formulalocal = "=SI(A4="";"";SI(A4="";"";GAUCHE(A4;TROUVE(" ";A4))))"
range("c4").formulalocal = "=SI(A4="";"";STXT(GAUCHE(A4;CHERCHE(CAR(255);SUBSTITUE(A4;" ";CAR(255);2)));TROUVE(" ";A4)+1;99))"
range("d4").formulalocal = "==SI(A4="";"";STXT(GAUCHE($A$4;CHERCHE(CAR(255);SUBSTITUE($A$4;" ";CAR(255);3)));CHERCHE(CAR(255);SUBSTITUE($A$4;" ";CAR(255);2))+1;99))"
range("g4").formulelocal = "=SI($A4="";"";STXT($A4;CHERCHE("|";SUBSTITUE($A4;" ";"|";NBCAR($A4)-NBCAR(SUBSTITUE($A4;" ";""))))+1;99))"