Use this formula...

=A18&" "&TEXT(B18,"DD-MMM")

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"mike_vr" wrote:

Hi there

Trying a very simple concatenation =A18 & " " & B18 but the problem is, B18
is a date. So whenever it calculates it comes back as "National Enquirer
40057" instead of "National Enquirer 01-Sep" as the two cells currently hold.

Is there something I'm missing from my formula?

Thanks
Mike