Date Format - CONCATENATE

[Yok33]

The image below describes what I am asking.

I am using Microsoft® Excel® 2016 MSO (Version 2201 Build 16.0.14827.20028) 32-bit

[#2 · Accepted solution]

@Yok33 

Use

=TEXT(A1, "mmmm yyyy")&" Total Sales:"

[#3]

@Hans Vogelaar 

"Excellent"!  Thank you so much.

Yok33