Don't bother to concatenate, just format Date as dddd mmmm d, yyyy

But, to answer your question on getting rid of the serial number and entering a
space.

=B1& " " &TEXT(C1,"mmmm d" &"," &"yyyy")

with Monday in B1 and May 8, 2008 in C1


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 20:37:01 -0800, Learningfast
wrote:

HI
My data is two values
Day Monday
Date May 8, 2008

The new result it
Concatenate #1 Monday34567 (the result has no space and there is a number
instead of the date).

Question: How do I program a space between the two and
Question: How do I format the date as text so it looks like a date?

Thanks!
Heather