Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Coverting Formula to Text | Excel Discussion (Misc queries) | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
formula is displaying as text rather than result. | Excel Worksheet Functions |