{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Feuil1","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"On recherche une chaîne dans une autre dans la même configuration"]
["IOWA ARKANSAS OHIO","IOWA ARKANSAS",{"$f":"IF(ISNUMBER(FIND(B2,A2)),B2,\"\")","v":"IOWA ARKANSAS"},"Formule : =SI(ESTNUM(TROUVE(B1;A1));B1;\"\")"]
[]
[null,null,"On recherche des éléments dans une chaîne pourvant se trouver dans le désordre"]
["IOWA ARKANSAS OHIO","IOWA OHIO OREGON",{"$f":"commun(B5,A5)","v":"IOWA OHIO "},"Fonction personnalisée =commun(cellule de la chaîne à chercher; cellule de la chaîne où chercher)"]
["IOWA ARKANSAS OHIO","IOWA FLORIDE OHIO",{"$f":"commun(B6,A6)","v":"IOWA OHIO "},"ALT + F11 pour ouvrir l'éditeur VBA"]
["IOWA ARKANSAS OHIO","ARKANSAS IOWA OHIO",{"$f":"commun(B7,A7)","v":"ARKANSAS IOWA OHIO "},"Aller dans Module 1 pour voir la macro de la fonction"]
["IOWA ARKANSAS OHIO","OREGON OHIO FLORIDE",{"$f":"commun(B8,A8)","v":"OHIO "}]
["IOWA ARKANSAS OHIO","OREGON  FLORIDE",{"$f":"commun(B9,A9)","v":" "}]