{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["01_TEO","02_Zak","03_col_row","04_shoda","05_nejsou"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":31,"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":"01_TEO","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,2,7],[7,0,7,14],[8,0,8,14],[49,0,49,4],[49,8,49,14],[13,2,13,12],[18,2,18,12],[27,2,27,3],[28,2,28,3],[32,4,33,12]]}
["Funkce v Excel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Textové"]
[]
[]
[]
[]
[]
["ROZDĚLIT.TEXT\n(TEXTSPLIT)"]
["Rozdělí text na řádky nebo sloupce pomocí oddělovačů."]
[]
[]
[null,"Syntaxe v češtině"]
[]
[null,null,"ROZDĚLIT.TEXT(text;col_delimiter;[row_delimiter];[ignore_empty];[match_mode];[pad_with])"]
[]
[]
[null,"Syntaxe v angličtině"]
[]
[null,null,"TEXTSPLIT(text;col_delimiter;[row_delimiter];[ignore_empty];[match_mode];[pad_with])"]
[]
[]
[null,"Popis argumentů"]
[]
[null,"text",null,"povinný","text který se má rozdělit"]
[null,"col_delimiter",null,"povinný","podle kterého znaku rozdělit na sloupce"]
[null,"row_delimiter",null,"volitelný","podle kterého znaku rozdělit na řádky"]
[null,"ignore_empty",null,"volitelný","Ignorovat prázdné, pokud neuvedeno NEPRAVDA"]
[null,null,false,null,"neignorovat prázdné buňky"]
[null,null,null,true,"ignorovat prázdné buňky"]
[null,"match_mode",null,"volitelný","vyhledá shodu s oddělovačem textu. Výchozí 0 "]
[null,null,null,0,"Ve výchozím nastavení rozlišuje velká a malá písmena"]
[null,null,null,1,"Nerozlišuje velká a malá písmena"]
[null,"pad_with",null,"volitelný","hodnota pro odsazení aneb co v případě že není hodnota (vychozí hodnota  #NENÍ_K_DISPOZICI, #N/A) "]
[]
[]
[null,"Poznámky"]
[]
[]
[]
[]
[]
[null,"Omezení"]
[null,"Dostupná v Office 365"]
[null,"Pracuje s dynamickou oblasti."]
[]
[]
[]
[]
[]
["Pavel Lasák, MVP - 2023",null,null,null,null,null,null,null,"https://office.lasakovi.com"]

{"sheet":"02_Zak","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[59,0,59,9],[60,0,60,9],[7,3,7,4],[12,3,12,6],[17,3,17,4],[16,3,16,4],[18,3,18,4],[26,3,26,6],[29,3,29,4],[30,3,30,4],[31,3,31,4],[39,3,39,6],[43,3,43,6],[47,3,47,6]]}
["ROZDĚLIT.TEXT (TEXTSPLIT) - základy sloupce"]
["http://office.lasakovi.com"]
[]
[]
[null,"Rozdělit po v řádku - oddělovač sloupců středník"]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":8},"Text",null,"Výsledek_1",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":9},"Abc;def",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B9;\";\")"]
[]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":13},"Text",null,"Výsledek_2",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":14},"A;B;C;D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B14;\";\")"]
[]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":18},"Text",null,"Výsledek_3",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":19},"A,B,C,D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B19;\";\")"]
[]
[null,"potřebujete rozdělit podle středníků, ale v textu středníky nejsou"]
[]
[]
[null,"Rozdělit po v řádku - oddělovač čárka"]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":27},"Text",null,"Výsledek_1",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":28},"A,B,C,D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B28;\",\")"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":31},"Text",null,"Výsledek_2",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":32},"A;B;C;D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B32;\",\")"]
[]
[null,"potřebujete rozdělit podle čárek, ale v textu čárky nejsou"]
[]
[]
[null,"Rozdělit po v řádku - oddělovač písmeno x"]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":40},"Text",null,"Výsledek_1",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":41},"AxBxCxD",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B41;\"x\")"]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":44},"Text",null,"Výsledek_2",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":45},"AxBXCxD",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B45;\"x\")"]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":48},"Text",null,"Výsledek_2",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":49},"AxBxxD",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B49;\"x\")"]
[]
[null,"viz dále mezery a velká a malá písmena"]
[]
[]
[]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - revize 2023"]

{"sheet":"03_col_row","index":2,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,0,60,9],[61,0,61,9],[0,0,0,9],[1,0,1,9],[7,3,7,4],[13,3,13,6],[21,3,21,4]]}
["ROZDĚLIT.TEXT (TEXTSPLIT) - základy řádky sloupce"]
["http://office.lasakovi.com"]
[]
[]
[null,"Rozdělit - oddělovač sloupců středník, řádků lomítko"]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":8},"Text",null,"Výsledek_1",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":9},"A;B/C;D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B9;\";\";\"/\")"]
[]
[]
[]
[null,"B",null,"D","E","F","G"]
[{"$f":"ROW()","v":14},"Text",null,"Výsledek_2",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":15},"A;B;C;D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B15;\";\";\"/\")"]
[]
[]
[]
[null,"Rozdělit - oddělovač sloupců lomítko, řádky středník"]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":22},"Text",null,"Výsledek_3",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":23},"A/B;C/D",null,null,null,null,null,null,"=ROZDĚLIT.TEXT(B23;\"/\";\";\")"]
[]
[]
[]
[null,"Rozdělit - oddělovač sloupců nic, řádků lomítko"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":30},"Text",null,"Výsledek",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":31},"A/B/C/D",null,{"$f":"_xlfn.TEXTSPLIT(B31,\";\",\"/\")","v":"A"},null,null,null,null,{"$f":"_xlfn.FORMULATEXT(D31)","v":"=ROZDĚLIT.TEXT(B31;\";\";\"/\")"}]
[null,null,null,"B"]
[null,null,null,"C"]
[null,null,null,"D"]
[]
[null,"Pokud potřeba jen řádky do sloupců vložit neexistující znak"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":39},"Text",null,"Výsledek",null,null,null,null,"Funkce"]
[{"$f":"ROW()","v":40},"A/B/C/D",null,{"$f":"_xlfn.TEXTSPLIT(B40,\"---\",\"/\")","v":"A"},null,null,null,null,{"$f":"_xlfn.FORMULATEXT(D40)","v":"=ROZDĚLIT.TEXT(B40;\"---\";\"/\")"}]
[null,null,null,"B"]
[null,null,null,"C"]
[null,null,null,"D"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - revize 2023"]

{"sheet":"04_shoda","index":3,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[7,3,7,4],[59,0,59,7],[60,0,60,7],[12,3,12,4],[22,3,22,4],[17,3,17,4],[18,6,19,6],[23,6,24,6]]}
["ROZDĚLIT.TEXT (TEXTSPLIT) - zahrnutí a shoda"]
["http://office.lasakovi.com"]
[]
[]
[null,"Rozdělit - oddělovač sloupců středník, řádků lomítko - prazdné zahrnout/nezhrnout"]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":8},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":9},"A;B/C;D",null,null,null,null,"=ROZDĚLIT.TEXT(B9;\";\";\"/\")"]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":13},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":14},"A;/;D",null,null,null,null,"=ROZDĚLIT.TEXT(B14;\";\";\"/\")"]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":18},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":19},"A;/;D",null,null,null,null,"=ROZDĚLIT.TEXT(B19;\";\";\"/\";NEPRAVDA)"]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":23},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":24},"A;/;D",null,null,null,null,"=ROZDĚLIT.TEXT(B24;\";\";\"/\";PRAVDA)"]
[]
[]
[]
[null,"Rozdělit - oddělovač sloupců středník, řádků x - přesná nepřesná shoda"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":31},"Text",null,"Výsledek_1",null,null,"Funkce"]
[{"$f":"ROW()","v":32},"AxBxCxD",null,null,null,null,"=ROZDĚLIT.TEXT(B32;\";\";\"x\")"]
[]
[]
[]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":38},"Text",null,"Výsledek_1",null,null,"Funkce"]
[{"$f":"ROW()","v":39},"AxBXCxD",null,{"$f":"_xlfn.TEXTSPLIT(B39,\";\",\"x\")","v":"A"},null,null,"=ROZDĚLIT.TEXT(B39;\";\";\"x\")"]
[null,null,null,"BXC"]
[null,null,null,"D"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":44},"Text",null,"Výsledek_1",null,null,"Funkce"]
[{"$f":"ROW()","v":45},"AxBXCxD",null,{"$f":"_xlfn.TEXTSPLIT(B45,\";\",\"x\",,0)","v":"A"},null,null,"=ROZDĚLIT.TEXT(B45;\";\";\"x\";;0)"]
[null,null,null,"BXC"]
[null,null,null,"D"]
[]
[null,"B",null,"D"]
[{"$f":"ROW()","v":50},"Text",null,"Výsledek_1",null,null,"Funkce"]
[{"$f":"ROW()","v":51},"AxBXCxD",null,{"$f":"_xlfn.TEXTSPLIT(B51,\";\",\"x\",,1)","v":"a"},null,null,"=ROZDĚLIT.TEXT(B51;\";\";\"x\";;1)"]
[null,null,null,"b"]
[null,null,null,"c"]
[null,null,null,"d"]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - revize 2023"]

{"sheet":"05_nejsou","index":4,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[[24,3,24,4],[25,6,26,6],[60,0,60,7],[61,0,61,7],[0,0,0,7],[1,0,1,7],[7,3,7,4],[12,3,12,4],[18,3,18,4],[19,6,20,6]]}
["ROZDĚLIT.TEXT (TEXTSPLIT) - nejsou hodnoty"]
["http://office.lasakovi.com"]
[]
[]
[null,"Rozdělit - oddělovač sloupců středník, řádků lomítko - co v případě že není hodnota"]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":8},"Text",null,"Výsledek_1",null,null,"Funkce"]
[{"$f":"ROW()","v":9},"A;B/C;D",null,null,null,null,"=ROZDĚLIT.TEXT(B9;\";\";\"/\")"]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":13},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":14},"A/B;C/D",null,null,null,null,"=ROZDĚLIT.TEXT(B14;\";\";\"/\")"]
[]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":19},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":20},"A/B;C/D",null,null,null,null,"=ROZDĚLIT.TEXT(B20;\";\";\"/\";;;\" \")"]
[]
[]
[]
[null,"B",null,"D","E"]
[{"$f":"ROW()","v":25},"Text",null,"Výsledek_2",null,null,"Funkce"]
[{"$f":"ROW()","v":26},"A/B;C/D",null,null,null,null,"=ROZDĚLIT.TEXT(B26;\";\";\"/\";;;\"?\")"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://office.lasakovi.com"]
["Pavel Lasák - revize 2023"]