SOLVED

Text and today date

%3CLINGO-SUB%20id%3D%22lingo-sub-1826827%22%20slang%3D%22en-US%22%3EText%20and%20today%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826827%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20doing%20an%20excel%20course%20and%20trying%20to%20create%20a%20formula%20like%20the%20below%20which%20doesn't%20give%20me%20the%20result%20I%20want.%20How%20do%20I%20create%20an%20space%20between%20IS%20and%20OCTOBER%3F%3C%2FP%3E%3CP%3E%3D%22TODAY%20IS%22%26amp%3B%22%22%26amp%3BTEXT(TODAY()%2C%22MMMM%22)%3C%2FP%3E%3CP%3ETODAY%20ISOCTOBER%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1826827%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1826964%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20and%20today%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F848746%22%20target%3D%22_blank%22%3E%40Guio83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELike%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%22TODAY%20IS%20%22%26amp%3BTEXT(TODAY()%2C%22MMMM%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829065%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20and%20today%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bstill%20same%20problem%2C%20no%20space%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.