Using the TEXT function and Concatenate function in one formula

[Marsau]

Hi There
I have a formula with concatenate:
=CONCATENATE('Sheet1'!E5," ",'Sheet1'!G5)

And would like to wrap this in a text function
e5 is month and g5 year

to ensure it shows as text in the following format "mmmm yyyy"

help plz

[p45cal]

Assuming G5 and E5 are both numeric, then:
=TEXT(DATE(Sheet1!G5,Sheet1!E5,1),"mmmm yyyy")

[Marsau]

Thank you