Simple concatenation including date
 

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

Simple concatenation including date
 

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

Simple concatenation including date
 

replace B18
with TEXT(B18,"dd mmm")
--
Wag more, bark less


"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

Simple concatenation including date
 

Hi Mike
Try it this way =A18 & " " & TEXT(B18,"dd,mmm")
HTH
John
"mike_vr" wrote in message
...
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