Find a Quarter Number from Given Date

A custom formula using two functions and return quarter number from given date, based on calendar year.

   =ROUNDUP(MONTH(A1)/3,0)

Get first word of a cell

To extract first word from a cell, create a custom formula by combining LEFT() and FIND()

    =LEFT(A1,FIND(" ",A1,1)-1)