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