MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Concatenation of date


Posted by J Savery on November 05, 2001 9:26 AM

I have a SS with a date in a cell and would like to concatenate it with some text (e.g. 'Report date: '&a1), however when I use the wizard, I get the number of the date as output.

Please advise.

Thanks,
Jamie


Posted by IML on November 05, 2001 9:47 AM

Try using
="report date "&TEXT(A1,"mmm d, yyyy")
and modify the format as needed ("mm/dd/yy")

good luck

Posted by J Savery on November 05, 2001 11:53 AM

That worked great. I knew it was simple, just didn't know which function to use.
Thanks,
Jamie

Posted by J Savery on November 05, 2001 11:53 AM

That worked great. I knew it was simple, just didn't know which function to use.
Thanks,
Jamie