Marsau
10-28-2022, 11:53 PM
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
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