SOLVED

Date Format - CONCATENATE

Occasional 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