Excel 2003 question [Solved/Closed]

Report
Posts
2
Registration date
Tuesday September 1, 2009
Status
Member
Last seen
September 2, 2009
-
Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
-
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

Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
218
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday September 1, 2009
Status
Member
Last seen
September 2, 2009

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!
Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
218
its a pleasure to help

see ya