This video explains how to use array function in Google Sheets. Here it is explained that the extraction of a specific month from a long data format.
Function
=ARRAYFORMULA(TEXT(DATEVALUE(LEFT(A2:A2931,10)),"MMMM"))
#google #googlesheets #googlesheetstutorial #rover #array