Get name of a month name from the text strin in the cell-CodePudding

I'm trying to find a way to get the name of the month from text string in a google sheet. I have:

enter date is November 5th 2022

and I need to get in the cell November as result.

CodePudding user response：

If it is string then use-

=INDEX(SPLIT(A1, " "),1,1)

And if it is true date, formatted as desired then use below formula to extract month as full name.

=TEXT(A1,"mmmm")

CodePudding user response：

can you try:

=REGEXEXTRACT(A2,"(?i)"&JOIN("|",INDEX(UNIQUE(TEXT(SEQUENCE(365,1,DATE(2022,1,1),1),"\\b"&"MMMM"&"\\b")))))