Simple concatenation including date

[mike_vr]

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

 

[Ms-Exl-Learner]

Use this formula...

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

If this post helps, Click Yes!

 

[Brad]

replace B18
with TEXT(B18,"dd mmm")

 

[John]

Hi Mike
Try it this way =A18 & " " & TEXT(B18,"dd,mmm")
HTH
John