{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tekst splitsen"],"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":"Tekst splitsen","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"MET INGEBOUWDE FUNCTIES (MAXIMAAL 2 DELEN)"]
[null,"maximum aantal karakters?",25]
[null,null,null,null,"gesplitste tekst"]
[null,"volledige te splitsen tekst","hulpcel","hulpcel","deel 1","deel 2"]
[null,"dit is een voorbeeld tekst van ongeveer 50 tekens die te lang is",{"$f":"IF(AND(MID(B7,$C$4,1)<>\" \",MID(B7,$C$4+1,1)=\" \"),$C$4,IF(ISERROR(FIND(\" \",B7)),MIN($C$4,LEN(B7)),FIND(\"^\",SUBSTITUTE(LEFT(B7,$C$4),\" \",\"^\",LEN(LEFT(B7,$C$4))-LEN(SUBSTITUTE(LEFT(B7,$C$4),\" \",\"\"))))))","v":21},{"$f":"IF(LEN(TRIM(B7))>C7,IF(OR(LEN(TRIM(B7))-C7<=$C$4,LEN(MID(B7,C7+1,$C$4))-LEN(SUBSTITUTE(MID(B7,C7+1,$C$4),\" \",\"\"))<2),MIN($C$4,LEN(B7)-C7),FIND(\"^\",SUBSTITUTE(MID(B7,C7+1,$C$4),\" \",\"^\",LEN(MID(B7,C7+1,$C$4))-LEN(SUBSTITUTE(MID(B7,C7+1,$C$4),\" \",\"\"))))),0)","v":22},{"$f":"TRIM(LEFT(B7,C7))","v":"dit is een voorbeeld"},{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(B7,E7,\"\",1),\" \",\"\"))=0,\"\",TRIM(MID(B7,C7+1,MIN($C$4,D7))))","v":"tekst van ongeveer 50"}]
[null,"dit is regel twee met deze tekst",{"$f":"IF(AND(MID(B8,$C$4,1)<>\" \",MID(B8,$C$4+1,1)=\" \"),$C$4,IF(ISERROR(FIND(\" \",B8)),MIN($C$4,LEN(B8)),FIND(\"^\",SUBSTITUTE(LEFT(B8,$C$4),\" \",\"^\",LEN(LEFT(B8,$C$4))-LEN(SUBSTITUTE(LEFT(B8,$C$4),\" \",\"\"))))))","v":22},{"$f":"IF(LEN(TRIM(B8))>C8,IF(OR(LEN(TRIM(B8))-C8<=$C$4,LEN(MID(B8,C8+1,$C$4))-LEN(SUBSTITUTE(MID(B8,C8+1,$C$4),\" \",\"\"))<2),MIN($C$4,LEN(B8)-C8),FIND(\"^\",SUBSTITUTE(MID(B8,C8+1,$C$4),\" \",\"^\",LEN(MID(B8,C8+1,$C$4))-LEN(SUBSTITUTE(MID(B8,C8+1,$C$4),\" \",\"\"))))),0)","v":10},{"$f":"TRIM(LEFT(B8,C8))","v":"dit is regel twee met"},{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(B8,E8,\"\",1),\" \",\"\"))=0,\"\",TRIM(MID(B8,C8+1,MIN($C$4,D8))))","v":"deze tekst"}]
[null,"enz enz enz ",{"$f":"IF(AND(MID(B9,$C$4,1)<>\" \",MID(B9,$C$4+1,1)=\" \"),$C$4,IF(ISERROR(FIND(\" \",B9)),MIN($C$4,LEN(B9)),FIND(\"^\",SUBSTITUTE(LEFT(B9,$C$4),\" \",\"^\",LEN(LEFT(B9,$C$4))-LEN(SUBSTITUTE(LEFT(B9,$C$4),\" \",\"\"))))))","v":12},{"$f":"IF(LEN(TRIM(B9))>C9,IF(OR(LEN(TRIM(B9))-C9<=$C$4,LEN(MID(B9,C9+1,$C$4))-LEN(SUBSTITUTE(MID(B9,C9+1,$C$4),\" \",\"\"))<2),MIN($C$4,LEN(B9)-C9),FIND(\"^\",SUBSTITUTE(MID(B9,C9+1,$C$4),\" \",\"^\",LEN(MID(B9,C9+1,$C$4))-LEN(SUBSTITUTE(MID(B9,C9+1,$C$4),\" \",\"\"))))),0)","v":0},{"$f":"TRIM(LEFT(B9,C9))","v":"enz enz enz"},{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(B9,E9,\"\",1),\" \",\"\"))=0,\"\",TRIM(MID(B9,C9+1,MIN($C$4,D9))))","v":""}]
[null,"dit is een voorbeeldtekst of iets dergelijks",{"$f":"IF(AND(MID(B10,$C$4,1)<>\" \",MID(B10,$C$4+1,1)=\" \"),$C$4,IF(ISERROR(FIND(\" \",B10)),MIN($C$4,LEN(B10)),FIND(\"^\",SUBSTITUTE(LEFT(B10,$C$4),\" \",\"^\",LEN(LEFT(B10,$C$4))-LEN(SUBSTITUTE(LEFT(B10,$C$4),\" \",\"\"))))))","v":25},{"$f":"IF(LEN(TRIM(B10))>C10,IF(OR(LEN(TRIM(B10))-C10<=$C$4,LEN(MID(B10,C10+1,$C$4))-LEN(SUBSTITUTE(MID(B10,C10+1,$C$4),\" \",\"\"))<2),MIN($C$4,LEN(B10)-C10),FIND(\"^\",SUBSTITUTE(MID(B10,C10+1,$C$4),\" \",\"^\",LEN(MID(B10,C10+1,$C$4))-LEN(SUBSTITUTE(MID(B10,C10+1,$C$4),\" \",\"\"))))),0)","v":19},{"$f":"TRIM(LEFT(B10,C10))","v":"dit is een voorbeeldtekst"},{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(B10,E10,\"\",1),\" \",\"\"))=0,\"\",TRIM(MID(B10,C10+1,MIN($C$4,D10))))","v":"of iets dergelijks"}]
[null,{"$f":"REPT(\"a\",52)","v":"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"},{"$f":"IF(AND(MID(B11,$C$4,1)<>\" \",MID(B11,$C$4+1,1)=\" \"),$C$4,IF(ISERROR(FIND(\" \",B11)),MIN($C$4,LEN(B11)),FIND(\"^\",SUBSTITUTE(LEFT(B11,$C$4),\" \",\"^\",LEN(LEFT(B11,$C$4))-LEN(SUBSTITUTE(LEFT(B11,$C$4),\" \",\"\"))))))","v":25},{"$f":"IF(LEN(TRIM(B11))>C11,IF(OR(LEN(TRIM(B11))-C11<=$C$4,LEN(MID(B11,C11+1,$C$4))-LEN(SUBSTITUTE(MID(B11,C11+1,$C$4),\" \",\"\"))<2),MIN($C$4,LEN(B11)-C11),FIND(\"^\",SUBSTITUTE(MID(B11,C11+1,$C$4),\" \",\"^\",LEN(MID(B11,C11+1,$C$4))-LEN(SUBSTITUTE(MID(B11,C11+1,$C$4),\" \",\"\"))))),0)","v":25},{"$f":"TRIM(LEFT(B11,C11))","v":"aaaaaaaaaaaaaaaaaaaaaaaaa"},{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(B11,E11,\"\",1),\" \",\"\"))=0,\"\",TRIM(MID(B11,C11+1,MIN($C$4,D11))))","v":"aaaaaaaaaaaaaaaaaaaaaaaaa"}]
[]
[]
[null,"MET EEN USER DEFINED FUNCTION (ZIE MODULE)",null,null,"gesplitste tekst"]
[null,null,null,null,"deel 1","deel 2","deel 3"]
[null,{"$f":"B7","v":"dit is een voorbeeld tekst van ongeveer 50 tekens die te lang is"},null,null,{"$f":"SplitText(B16,1,25)","v":"dit is een voorbeeld"},{"$f":"SplitText(B16,2,25)","v":"tekst van ongeveer 50"},{"$f":"SplitText(B16,3,25)","v":"tekens die te lang is"}]
[null,{"$f":"B8","v":"dit is regel twee met deze tekst"},null,null,{"$f":"SplitText(B17,1,25)","v":"dit is regel twee met"},{"$f":"SplitText(B17,2,25)","v":"deze tekst"},{"$f":"SplitText(B17,3,25)","v":""}]
[null,{"$f":"B9","v":"enz enz enz "},null,null,{"$f":"SplitText(B18,1,25)","v":"enz enz enz"},{"$f":"SplitText(B18,2,25)","v":""},{"$f":"SplitText(B18,3,25)","v":""}]
[null,{"$f":"B10","v":"dit is een voorbeeldtekst of iets dergelijks"},null,null,{"$f":"SplitText(B19,1,25)","v":"dit is een voorbeeldtekst"},{"$f":"SplitText(B19,2,25)","v":"of iets dergelijks"},{"$f":"SplitText(B19,3,25)","v":""}]
[null,{"$f":"B11","v":"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"},null,null,{"$f":"SplitText(B20,1,25)","v":""},{"$f":"SplitText(B20,2,25)","v":""},{"$f":"SplitText(B20,3,25)","v":""}]
[]
[]
[]
[null,"Dit bestandje bevat VBA-code om de inhoud van een cel te splitsen in delen waarvan je zelf de maximale lengte ingeeft."]
[null,"Er wordt tevens gesplitst op spaties, zodat geen woorden of getallen afgebroken worden."]
[null,"De functie SplitText heeft 3 argumenten: te splitsen tekst (mag een celverwijzing zijn), het hoeveelste deel je wilt weergeven, maximum aantal karakters per deel"]
[]
[null,"Wim Gielis"]
[null,"2007-06-09"]
[null,{"$f":"HYPERLINK(\"http://www.wimgielis.be\",\"Website\")","v":"Website"}]