Previous Topic Next Topic

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!

2 replies

Answer 1 / 2
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
2
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!
0
Answer 2 / 2
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
0