{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sayfa1"],"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":"Sayfa1","index":0,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["данные","результат"]
["abc1234def26",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\")","v":"abcdef"},{"$f":"SUM(MID(0&A2,LARGE(ISNUMBER(--MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))\n  *ROW(INDIRECT(\"1:\"&LEN(A2))),ROW(INDIRECT(\"1:\"&LEN(A2))))+1,1)\n    *10^ROW(INDIRECT(\"1:\"&LEN(A2)))/10)","v":123426}]
["istak15tak44p",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\")","v":"istaktakp"},{"$f":"SUM(MID(0&A3,LARGE(ISNUMBER(--MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))\n  *ROW(INDIRECT(\"1:\"&LEN(A3))),ROW(INDIRECT(\"1:\"&LEN(A3))))+1,1)\n    *10^ROW(INDIRECT(\"1:\"&LEN(A3)))/10)","v":1544},null,"По мере увеличения числа отдельных формул мне нужно формулу, которая отделяет текст."]
["ııı154bb48",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A4,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\")","v":"ıııbb"},{"$f":"SUM(MID(0&A4,LARGE(ISNUMBER(--MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))\n  *ROW(INDIRECT(\"1:\"&LEN(A4))),ROW(INDIRECT(\"1:\"&LEN(A4))))+1,1)\n    *10^ROW(INDIRECT(\"1:\"&LEN(A4)))/10)","v":15448}]