SOLVED

Text and today date

Copper Contributor

Good morning,

 

I am doing an excel course and trying to create a formula like the below which doesn't give me the result I want. How do I create an space between IS and OCTOBER?

="TODAY IS"&""&TEXT(TODAY(),"MMMM")

TODAY ISOCTOBER

3 Replies
best response confirmed by Guio83 (Copper Contributor)
Solution

@Guio83 

Like this:

 

="TODAY IS "&TEXT(TODAY(),"MMMM")

 

@Hans Vogelaar still same problem, no space,

Sorry, it worked! I didn't realize that I had to leave a space between is and ".

Thank youu.

1 best response

Accepted Solutions
best response confirmed by Guio83 (Copper Contributor)
Solution

@Guio83 

Like this:

 

="TODAY IS "&TEXT(TODAY(),"MMMM")

 

View solution in original post