Formula and Text in One Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luddite - 23 Aug 2007 17:44 GMT

Is it possible to have a cell with a formula and still include text. It is
easy enough to generate a calendar, (basically I'm creating the calendar by
dragging a date to other cells) but once I have the calendar, I want to be
able to insert text into the individual cells. For example, in a cell that
is formatted with a date 08/23/07, is there a way to include some text such
as Abby's Birthday?

Reply to this Message

Gary''s Student - 23 Aug 2007 17:48 GMT

=TEXT(TODAY(),"dd/mm/yy") & " hope it's a good one"

Signature

Gary''s Student - gsnu200738

> Is it possible to have a cell with a formula and still include text. It is
> easy enough to generate a calendar, (basically I'm creating the calendar by
> dragging a date to other cells) but once I have the calendar, I want to be
> able to insert text into the individual cells. For example, in a cell that
> is formatted with a date 08/23/07, is there a way to include some text such
> as Abby's Birthday?

Reply to this Message

Luddite - 23 Aug 2007 20:06 GMT

> =TEXT(TODAY(),"dd/mm/yy") & " hope it's a good one"

Thanks. That's very helpful. One more question. How to I chage the date
format if I want it to print as Aug 23 instead of 23/08/2007?

Reply to this Message

Duke Carey - 23 Aug 2007 20:20 GMT

"mmm dd"

> > =TEXT(TODAY(),"dd/mm/yy") & " hope it's a good one"
>
> Thanks. That's very helpful. One more question. How to I chage the date
> format if I want it to print as Aug 23 instead of 23/08/2007?

Reply to this Message

Luddite - 23 Aug 2007 21:30 GMT

> "mmm dd"

Thanks. Seems easy enough, but I didn't think to try that.

Reply to this Message