mix text and formula?
 

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.

Like this??

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

--
Regards,
Ron


"A. Toczko" wrote:

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.

Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"A. Toczko" wrote in message
...
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.

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"A. Toczko" wrote in message
...
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.

Excellent! Thanks.
"Ron Coderre" wrote in message
...
Like this??

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

--
Regards,
Ron


"A. Toczko" wrote:

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.