Previous Topic Next Topic

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

Answer 1 / 2
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
Thank you

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

CCM 2821 users have said thank you to us this month

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

see ya
Ask a question