Concatenate

  • Thread starter Thread starter SJT
  • Start date Start date
S

SJT

I am attempting to use the concatenate function to combine some text with
dates from two different cells. However, the result gives me the serial
number associated w/ the date as opposed to the format "October 16, 2008".
The cell is formatted as a date. I am using Excel 2003 in XP. Thank you in
advance for your assistance.
 
Can you provide samples of the data you're trying to concatenate, and show
how you'd like the result to display?
 
=CONCATENATE(G45," ",C45," ",D45," ",E45)
This is the formula I've used. E45 is a date. I've tried using 'TEXT' in
the formula but keep getting an error message. Can someone write me a
formula??
 
=G45 & " " & c45 & " " & D45 & " " & TEXT(E45,"mmmm dd, yyyy")


Gord Dibben MS Excel MVP
 
Back
Top