Wrapping a concatenate formula in a text formula

[oblix]

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

 

[Z51]

Rather than concatenating the fields, couldn't you just use:

=TEXT(Sheet1!E5,"mmmm")&" "&TEXT(Sheet1!G5,"yyyy")

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Using the TEXT function and Concatenate function in one formula
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[oblix]

Thank you it worked

 

[oblix]

Thank you for advice about posting on more than one forum