{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Replace","Strings_x_String","Strings_x_StringS","omkantine.de"],"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":"Replace","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["hier die Tabelle einfügen, die durchsucht werden soll!"]

{"sheet":"Strings_x_String","index":1,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Strings","Länge","Doppelt",{"$f":"LEN(C1)","v":7},{"$f":"COUNTIF(C:C,C1)","v":1},null,"Ersetzen durch:","hier bitte die Zeichenfolge eintragen die eingesetzt werden soll!"]
["SVWZ +",{"$f":"LEN(A2)","v":6},{"$f":"COUNTIF(A:A,A2)","v":1}]
["SVWZ+Bestellung . ",{"$f":"LEN(A3)","v":18},{"$f":"COUNTIF(A:A,A3)","v":1}]
["SVWZ+Bestell-Nr.. ",18,1]
["SVWZ+Bestellung .",17,1]
["SVWZ+Bestellung. ",17,1]
["SVWZ+Bestell-Nr. ",17,1]
["SVWZ+Bestellnr.. ",17,1]
["SVWZ+Bestell-Nr..",17,1]
["SVWZ+bestell-nr ",16,1]
["SVWZ+BestellNr. ",16,1]
["SVWZ+Bestellung ",16,1]
["SVWZ+Bestellnr..",16,1]
["SVWZ+BEST NR ",13,1]
["SVWZ+BEST. ",11,1]
["SVWZ+BEST.",10,1]
["SVWZ+VERW ",10,1]
["SVWZ+Nr. ",9,1]
["SVWZ ++",7,1]
["SVWZ+. ",7,1]
["SVWZ++",6,1]
["SVWZ: ",6,1]
["SVWZ+.",6,1]
["SVWZ+ ",6,1]
["SVWZ+",5,1]
["SVWZ:",5,1]

{"sheet":"Strings_x_StringS","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Replace","Länge","Doppelt","Replace with",{"$f":"LEN(D1)","v":12},{"$f":"COUNTIF(D:D,D1)","v":1}]
["Ã ",{"$f":"LEN(A2)","v":2},{"$f":"COUNTIF(A:A,A2)","v":1},"à"]
["Ã­",{"$f":"LEN(A3)","v":2},{"$f":"COUNTIF(A:A,A3)","v":1},"í"]
["Ã–",2,1,"Ö"]
["Ãˆ",2,1,"È"]
["Ã¡",2,1,"á"]
["Ã¨",2,1,"è"]
["Ã´",2,1,"ô"]
["Ã’",2,1,"Ò"]
["Ã‚",2,1,"Â"]
["Ã“",2,1,"Ó"]
["Ã”",2,1,"Ô"]
["Ã„",2,1,"Ä"]
["Ã›",2,1,"Û"]
["Ã¢",2,1,"â"]
["Ã¤",2,1,"ä"]
["Ã€",2,1,"À"]
["Ã»",2,1,"û"]
["Ã©",2,1,"é"]
["Ã¬",2,1,"ì"]
["Ã®",2,1,"î"]
["Ã¶",2,1,"ö"]
["Ã‰",2,1,"É"]
["Ã¼",2,1,"ü"]
["Ã½",2,1,"ý"]
["Ã¹",2,1,"ù"]
["Ã²",2,1,"ò"]
["Ã³",2,1,"ó"]
["Ãª",2,1,"ê"]
["Ãº",2,1,"ú"]
["Ãœ",2,1,"Ü"]
["Ãš",2,1,"Ú"]
["Ã™",2,1,"Ù"]
["ÃŸ",2,1,"ß"]
["ÃŽ",2,1,"Î"]

{"sheet":"omkantine.de","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blog Artikel:"]
[null,"http://www.omkantine.de/mehrere-zeichenfolgen-in-excel-suchen-und-ersetzen-per-makro/"]
[]
[null,"Download:"]
[null,"http://www.omkantine.de/attachments/Strings_Suchen_und_Ersetzen_Makro.xlsm"]