Excel 2003 question

Solved/Closed
TrinityIPB Posts 2 Registration date Tuesday September 1, 2009 Status Member Last seen September 2, 2009 - Sep 2, 2009 at 11:45 AM
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 - Sep 2, 2009 at 01:46 PM
Microsoft Office Excel 2003

I am trying to put in todays date along with text. How would i do this?


in box A43 i have:
=Q1&R1&S1

in Q1 i have BBS LIST FOR
in R1 i have =TODAY()
in S1 i have HOB 6PM - 12AM

so it would be as follows:
BBS LIST FOR =TODAY() HOB 6PM - 12AM

And this is how it is coming out.
BBS LIST FOR 40058 HOB 6PM - 12AM CW TRINITY

It should look like this:
BBS LIST FOR September 2, 2009 HOB 6PM - 12AM

Is there an easier way to do this so it will come out the way I want it?
Thanks in advance!
Related:

2 responses

sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 219
Sep 2, 2009 at 01:00 PM
Hello try the following formula:

= Q1 & TEXT(TODAY(),"mmm-dd-yyyy") & S1

or maybe

= Q1 & " " & TEXT(TODAY(),"mmm-dd-yyyy") & " " & S1

This will add a space in between

Text() function is used to format the date as string
TrinityIPB Posts 2 Registration date Tuesday September 1, 2009 Status Member Last seen September 2, 2009
Sep 2, 2009 at 01:31 PM
Sweeet! Thank you so much sadgurl! I may be back in a while with more questions if i cant firgure them out LOL!
Thanks again! You Rock!
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 219
Sep 2, 2009 at 01:46 PM
its a pleasure to help

see ya