excel how to show current month and year with space

0
votes

i want current month and year in a cell with space in between, I have used the formula =TEXT(AG1,"MMMM")&YEAR(AG1) but unable to get space in between in it.

1
excel
Have you tried CONCATENATE ? – Igoris Azanovas

1 Answers

2
votes
=TEXT(AG1,"MMMM")& " " & YEAR(AG1)

simpler:

=TEXT(AG1, "MMMM YYYY")