ExcelBanter - how do i combine text and formula calculation in same cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i combine text and formula calculation in same cell (https://www.excelbanter.com/excel-worksheet-functions/246126-how-do-i-combine-text-formula-calculation-same-cell.html)

GSM

how do i combine text and formula calculation in same cell

T. Valko

how do i combine text and formula calculation in same cell

An example...

="Today's date is "&TEXT(NOW(),"mmmm d yyyy")

--
Biff
Microsoft Excel MVP

"gsm" wrote in message
...

GSM

how do i combine text and formula calculation in same cell

Hi Biff

Many thanks for your reply. This really helps.

"T. Valko" wrote:

An example...

="Today's date is "&TEXT(NOW(),"mmmm d yyyy")

--
Biff
Microsoft Excel MVP

"gsm" wrote in message
...

.

T. Valko

how do i combine text and formula calculation in same cell

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

"gsm" wrote in message
...
Hi Biff

Many thanks for your reply. This really helps.

"T. Valko" wrote:

An example...

="Today's date is "&TEXT(NOW(),"mmmm d yyyy")

--
Biff
Microsoft Excel MVP

"gsm" wrote in message
...

.

All times are GMT +1. The time now is 05:30 PM.