SOLVED

Date Format - CONCATENATE

%3CLINGO-SUB%20id%3D%22lingo-sub-3113074%22%20slang%3D%22en-US%22%3EDate%20Format%20-%20CONCATENATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113074%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20image%20below%20describes%20what%20I%20am%20asking.%3C%2FP%3E%3CP%3E%3C!--%20%20%20StartFragment%20%20%20%20--%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EI%20am%20using%20Microsoft%C2%AE%20Excel%C2%AE%202016%20MSO%20(Version%202201%20Build%2016.0.14827.20028)%2032-bit%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2202-03-2022%20EXCEL%20CONCAT%20QUESTION.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345118iA844BF562ADC02BD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%2202-03-2022%20EXCEL%20CONCAT%20QUESTION.png%22%20alt%3D%2202-03-2022%20EXCEL%20CONCAT%20QUESTION.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3C!--%20%20%20EndFragment%20%20%20%20--%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3113074%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3113461%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20-%20CONCATENATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296507%22%20target%3D%22_blank%22%3E%40Yok33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%3DTEXT(A1%2C%20%22mmmm%20yyyy%22)%26amp%3B%22%20Total%20Sales%3A%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3113495%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20-%20CONCATENATE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Excellent%22!%26nbsp%3B%20Thank%20you%20so%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYok33%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

The image below describes what I am asking.

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

02-03-2022 EXCEL CONCAT QUESTION.png

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@Yok33 

Use

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

@Hans Vogelaar 

 

"Excellent"!  Thank you so much.

 

Yok33