{"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":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["пп","наименование","кек","кекн","енке","кенке","гншнгш","Ячейка ввода",null,"итого",null,"доп столбец"]
[1,"апрарапрап",null,null,null,null,null,null," 1) Иванов; 2) Петров А.А.; 3) Сидоров; 4) Косой; 5) Песец; 6) Трындец;",{"$f":"LEN(I5)-LEN(SUBSTITUTE(I5,\")\",\"\"))","v":6},null,{"$f":"CONCATENATE(I5,\" \",IF(H5=\"\",\"\",CONCATENATE(J5+1,\") \",H5,\";\")))","v":" 1) Иванов; 2) Петров А.А.; 3) Сидоров; 4) Косой; 5) Песец; 6) Трындец; "}]
["2","рооророр",null,null,null,null,null,null," 1) Иванов; 2) Петров А.А.;",{"$f":"LEN(I6)-LEN(SUBSTITUTE(I6,\";\",\"\"))","v":2},null,{"$f":"CONCATENATE(I6,\" \",IF(H6=\"\",\"\",CONCATENATE(J6+1,\") \",H6,\";\")))","v":" 1) Иванов; 2) Петров А.А.; "}]
["3","вапрпварар",null,null,null,null,null,"Иванов"," 1) Иванов;",{"$f":"LEN(I7)-LEN(SUBSTITUTE(I7,\";\",\"\"))","v":1},null," 1) Иванов; 2) Иванов;"]
[]
[null,null,null,null,null,null,null,null,"1. Вводим фамилию"]
[null,null,null,null,null,null,null,null,"2. Запускаем макрос (Ctrl+й)"]
[null,null,null,null,null,null,null,null,"макрос копирует данные ячейки L5 и вставляет как значения в ячейку I5. Очищает ячейку H5"]
[]
[]
[null,null,null,null,null,null,null,null,"как сделать так, чтоб автоматически менялось и срабатывало по всему столбцу H"]