Simple concatenation including date

  • Thread starter Thread starter mike_vr
  • Start date Start date
M

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
 
Use this formula...

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

If this post helps, Click Yes!
 
Back
Top