oblix
Board Regular
- Joined
- Mar 29, 2017
- Messages
- 183
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
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