Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
Matrix formulas do not require dragging, as they spill:Movie: =TEXTBEFORE(A2:A9,{":";" -"})Release Year: =TEXTAFTER(TEXTBEFORE(A2:A9," -",-1),":",-1,,,"")Producer: =TEXTAFTER(A2:A9," -",-1) 🤗
Good catch! That would certainly make it faster 👍
Matrix formulas do not require dragging, as they spill:
Movie: =TEXTBEFORE(A2:A9,{":";" -"})
Release Year: =TEXTAFTER(TEXTBEFORE(A2:A9," -",-1),":",-1,,,"")
Producer: =TEXTAFTER(A2:A9," -",-1) 🤗
Good catch! That would certainly make it faster 👍