View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Adding a date and name to auto update within one cell

You will probably want to format the date before joining it to a name,
and if you only want a date then you can use TODAY rather than NOW
(which gives you a time as well). So, try this:

=TEXT(TODAY(),"dd/mm/yy")&"your_name"

where "your_name" can be a cell reference, or a formula which returns
a name from a list.

Hope this helps.

Pete

On Jun 25, 9:34*pm, Cathie G
wrote:
Hello,
How can I add a date and name to update in a cell? Currently I have =NOW()
within the same cell I want to add a name (probably from a list).