Extract Text Faster with TEXTBEFORE and TEXTAFTER in Excel

[@JoseAntonioMorato]

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) 🤗

[@sheetskunk]

Good catch! That would certainly make it faster 👍