Size: a a a
EN
"=mid($K$1;1;QUERY({ARRAYFORMULA({arrayformula(REGEXMATCH({MID($K$1;row(INDIRECT(""a1:a""&len($K$1)));1)};""[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]""))*{false();arrayformula( not(REGEXMATCH({MID($K$1;row(INDIRECT(""a1:a""&len($K$1)-1));1)};""[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]"")))}})\arrayformula({row(INDIRECT(""a1:a""&len($K$1)))})};""select Col2 where Col1=1 limit 1 "")-1)&""."""NK
NK
EN
=arrayformula( mid($K$1;1;QUERY({({(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]"))*{false();( not(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)-1));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]")))}})\({row(INDIRECT("a1:a"&len($K$1)))})};"select Col2 where Col1=1 limit 1 ")-1)&".")NK
=arrayformula( mid($K$1;1;QUERY({({(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]"))*{false();( not(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)-1));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]")))}})\({row(INDIRECT("a1:a"&len($K$1)))})};"select Col2 where Col1=1 limit 1 ")-1)&".")А
А
v
"=mid($K$1;1;QUERY({ARRAYFORMULA({arrayformula(REGEXMATCH({MID($K$1;row(INDIRECT(""a1:a""&len($K$1)));1)};""[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]""))*{false();arrayformula( not(REGEXMATCH({MID($K$1;row(INDIRECT(""a1:a""&len($K$1)-1));1)};""[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]"")))}})\arrayformula({row(INDIRECT(""a1:a""&len($K$1)))})};""select Col2 where Col1=1 limit 1 "")-1)&""."""v
А
А
NK
А
NK
=arrayformula( mid($K$1;1;QUERY({({(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]"))*{false();( not(REGEXMATCH({MID($K$1;row(INDIRECT("a1:a"&len($K$1)-1));1)};"[А|а|У|у|Е|е|О|о|Ы|ы|Э|э|Я|я|И|и|Ю|ю]")))}})\({row(INDIRECT("a1:a"&len($K$1)))})};"select Col2 where Col1=1 limit 1 ")-1)&".")
NK
AI
А
EN
EN
EN