mix text and formula?

[A. Toczko]

I was wondering if there is a way to mix text and a formula in a cell. I'd
like to embed today's date (using the function =TODAY()) in the middle of a
sentence. Thanks.

 

[Guest]

Like this??

="On this date, "&TEXT(TODAY(),"mmmm dd, yyyy")&" I wrote this forumula."

 

[Ragdyer]

Try this:

="Today's date is "&TEXT(TODAY(),"mmm/dd/yy")&" , and you're Late!"

 

[Max]

Try something like:
="Date is: "&TEXT(TODAY(),"dd mmm yyyy")

Try also Debra's coverage on combining data at her:
http://www.contextures.com/xlCombine01.html
See especially the formatting examples towards the bottom of the page

 

[A. Toczko]

Excellent! Thanks.

Like this??

="On this date, "&TEXT(TODAY(),"mmmm dd, yyyy")&" I wrote this forumula."