ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add (auto text) to a paragraph? (https://www.excelbanter.com/excel-worksheet-functions/24682-how-do-i-add-auto-text-paragraph.html)

Lisa Nelson

How do I add (auto text) to a paragraph?
 
I"m trying to add "auto text" to a text paragraph. What I would like to do
is have the date automically appear and update when the file is opened.

Franz

"Lisa Nelson" <Lisa ha scritto nel
messaggio


I"m trying to add "auto text" to a text paragraph. What I would like
to do is have the date automically appear and update when the file is
opened.



You can use the function Today:

If you want the date standalone, in a cell insert the function =TODAY().

If you, instead, want the date inside text, in a cell insert this formula:

="first part of your text "&TODAY()&" second part of your text".

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------




All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com