Insert date and time into cell with existing text

B

bam

Question: I maintain an issues list in Excel. One column contains notes. I'd
like to somehow enter today's date (or today's date and time) into a cell
with existing text.

The eventual output would look like this (all in one cell)

08/20/07: some update about the issue. 08/18/07: some earlier update about
the issue
 
N

Niek Otten

Look here:

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Question: I maintain an issues list in Excel. One column contains notes. I'd
| like to somehow enter today's date (or today's date and time) into a cell
| with existing text.
|
| The eventual output would look like this (all in one cell)
|
| 08/20/07: some update about the issue. 08/18/07: some earlier update about
| the issue
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to extract few values from a cell 3
Special converting of string date&time to date format 3
Suming Up Time over the course of days 1
Linux turns 29: The biggest events in its history so far 5
Date value in cell with text 1
Charts - Time Duration 0
how to return "summary" of all non-blank cells plus their headers 10
Comparing Dates in 4 Columns - Nested Formulas? 2

Top