Concatenate Question

  • Thread starter Thread starter Learningfast
  • Start date Start date
L

Learningfast

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
 
Learningfast said:
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?
Click to expand...

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
 
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
 
Back
Top