{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WksContacts"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WksContacts","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,6,14,7],[15,6,15,7],[16,6,16,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[13,6,13,7]]}
["Prénom","Domaine","Courriel",null,"Etape 1","Etape 2","Etape 3","Etape 4"]
["Amaryllis","deveaux.famille","amaryllis@deveaux.famille",null,{"$f":"FIND(\"@\",C2)","v":10},{"$f":"LEN(C2)","v":25},{"$f":"MID(C2,E2+1,F2-1)","v":"deveaux.famille"},{"$f":"MID(C2,FIND(\"@\",C2)+1,LEN(C2)-1)","v":"deveaux.famille"}]
["Bob","cadacom.be","bob@cadacom.be",null,"=TROUVE(\"@\";C2)","=NBCAR(C2)","=STXT(C2;E2+1;F2-1)","=STXT(C2;TROUVE(\"@\";C2)+1;NBCAR(C2)-1)"]
["Bobbie","cadacom.be","bobbie@cadacom.be",null,"Position de \"@\"","Longueur texte","Extraction domaine","Intégration"]
["Bobette","cadacom.be","bobette@cadacom.be"]
["Damien","deveaux.famille","damien@deveaux.famille",null,"Règle de mise en forme conditionnelle ","Test","Formules"]
["Daniel","deveaux.famille","daniel@deveaux.famille",null,"Règle \"deveaux.famille\"",{"$f":"MID(C2,FIND(\"@\",C2)+1,LEN(C2)-1)=\"deveaux.famille\"","v":true},"=STXT(C2;TROUVE(\"@\";C2)+1;NBCAR(C2)-1)=\"deveaux.famille\""]
["Denis","deveaux.famille","denis@deveaux.famille",null,"Règle \"cadacom.be\"",{"$f":"MID(C2,FIND(\"@\",C2)+1,LEN(C2)-1)=\"cadacom.be\"","v":false},"=STXT(C2;TROUVE(\"@\";C2)+1;NBCAR(C2)-1)=\"cadacom.be\""]
["Domithilde","deveaux.famille","domithilde@deveaux.famille",null,"Règle \"amis.eu\"",{"$f":"MID(C2,FIND(\"@\",C2)+1,LEN(C2)-1)=\"amis.eu\"","v":false},"=STXT(C2;TROUVE(\"@\";C2)+1;NBCAR(C2)-1)=\"amis.eu\""]
["Erika","deveaux.famille","erika@deveaux.famille"]
["Guy","amis.eu","guy@amis.eu",null,"Dans cet exemple les règles sont à appliquer à la plage \"C2:C23\""]
["Harold","amis.eu","harold@amis.eu",null,"Si l'on souhaite que toute la ligne du tableau soit traités il convient de changer les formules et d'appliquer de \"A2:C23\""]
["Henri","amis.eu","henri@amis.eu"]
["Jean-Louis","amis.eu","jean-louis@amis.eu",null,"Règle de mise en forme conditionnelle ","Test","Formules"]
["Kuifje","cadacom.be","kuifje@cadacom.be",null,"Règle \"deveaux.famille\"",{"$f":"MID($C10,FIND(\"@\",$C10)+1,LEN($C10)-1)=\"deveaux.famille\"","v":true},"=STXT($C10;TROUVE(\"@\";$C10)+1;NBCAR($C10)-1)=\"deveaux.famille\""]
["Léandre","amis.eu","léandre@amis.eu",null,"Règle \"cadacom.be\"",{"$f":"MID($C10,FIND(\"@\",$C10)+1,LEN($C10)-1)=\"cadacom.be\"","v":false},"=STXT($C10;TROUVE(\"@\";$C10)+1;NBCAR($C10)-1)=\"cadacom.be\""]
["Milou","cadacom.be","milou@cadacom.be",null,"Règle \"amis.eu\"",{"$f":"MID($C10,FIND(\"@\",$C10)+1,LEN($C10)-1)=\"amis.eu\"","v":false},"=STXT($C10;TROUVE(\"@\";$C10)+1;NBCAR($C10)-1)=\"amis.eu\""]
["Paul","amis.eu","paul@amis.eu"]
["Robbedoes","cadacom.be","robbedoes@cadacom.be"]
["Spirou","amis.eu","spirou@amis.eu"]
["Suske","cadacom.be","suske@cadacom.be"]
["Tintin","cadacom.be","tintin@cadacom.be"]
["Wiske","cadacom.be","wiske@cadacom.be"]