{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Исходник","111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 1111111111,",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,\":\",),\";\",),\",\",),\".\",),\"!\",),\"?\",))","v":90},{"$f":"IF(C1>81,\"ОШИБКА!\",\"ОК\")","v":"ОШИБКА!"}]
["Проблема",{"$f":"LEFTB(B1,LOOKUP(81,SEARCH(\" \",B1&\" \",ROW($1:$81)))-1)","v":"111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111,"},{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,\":\",),\";\",),\",\",),\".\",),\"!\",),\"?\",))","v":69},{"$f":"IF(C2>81,\"ОШИБКА!\",\"ОК\")","v":"ОК"}]
["Нужный результат","111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,\":\",),\";\",),\",\",),\".\",),\"!\",),\"?\",))","v":79},{"$f":"IF(C3>81,\"ОШИБКА!\",\"ОК\")","v":"ОК"}]
[]
[null,"Расчет по формуле:  =NOPREPINAKI(B1;81) , где 81 - максимально возможная длина строки"]
[null,{"$f":"NOPREPINAKI(B1,81)","v":"111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111, 111111111"}]