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

Hi Heather

why don't you format the field to show the Name of the Day as well?
Custom format would be: dddd mmmm d, yyyy
or (if you want 3 letter months) dddd mmm d, yyyy

i hope i understood you right

Carlo

On Jan 16, 1:37*pm, 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

Learningfast wrote...
....
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?

May 8, 2008 is a Thursday.

The general answer is

=DayCell&TEXT(DateCell," mmmm d, yyyy")

but if you actually want Thursday May 8, 2008 (i.e., the actual day of
the week for the given date), ignore the Day cell and give the Date
cell the custom number format

dddd mmmm d, yyyy

You need to get a basic book on Excel. Excel stores dates as numbers.
January 1, 1900 is day 1. January 2, 1900 is day 2, January 15, 2008 is day
39462.
Just apply standard Excel date formatting to what you have. Such as a
standard Excel date by right clicking the cell with the date, format cells,
date, select 2nd entry and you will see Tuesday, January 15, 2008.

Tyro

"Learningfast" wrote in message
...
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

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