Displaying text along with formula results

I know there is a way to do thi, but i just cannot remember. Can anyone please tell me how I can include the words "Created on" with the NOW() function so that it is all in the same cell?

Thanks.

Try...

="Created on "&TEXT(NOW(),"mmmm d, yyyy")

...or, if you want to include time...

="Created on "&TEXT(NOW(),"mmmm d, yyyy h:mm:ss")

Change the date/time format accordingly.

Hope this helps!

Perfect! Thanks.