Home

Excell Upper

%3CLINGO-SUB%20id%3D%22lingo-sub-357699%22%20slang%3D%22en-US%22%3EExcell%20Upper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357699%22%20slang%3D%22en-US%22%3E%3CP%3EMorning.%20I%20have%20a%20cell%20with%20%22%3DDATE(%24K%241%2C%24K%242%2C1)%22%20to%20pull%20the%20month%20and%20year%20out%20of%20cells%20K1%20%26amp%3B%20K2.%20The%20result%20is%20%22January%202019%22.%20I%20would%20like%20to%20have%20the%20result%20be%20%22JANUARY%202019%22.%20Is%20there%20a%20way%20to%20do%20this%20in%20the%20same%20cell%20by%20imbedding%20the%20formulas%3F%20I've%20tried%20several%20solutions%20I%20thought%20would%20work%20and%20always%20seem%20to%20get%20some%20kind%20of%20error%20message.%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357699%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357726%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excell%20Upper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357726%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20glad%20to%20hear%20that!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357718%22%20slang%3D%22en-US%22%3ERE%3A%20Excell%20Upper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357718%22%20slang%3D%22en-US%22%3EThat%20did%20it!%20Explains%20one%20of%20the%20error%20messages%20I%20was%20getting%20as%20well.%20Thank%20you%20Twifoo!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357715%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Upper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357715%22%20slang%3D%22en-US%22%3ETry%20this%20formula%3A%3CBR%20%2F%3E%3DUPPER(TEXT(DATE(K1%2CK2%2C1)%2C%E2%80%9Dmmmm%20yyyy%E2%80%9D))%3C%2FLINGO-BODY%3E
kvandalia
New Contributor

Morning. I have a cell with "=DATE($K$1,$K$2,1)" to pull the month and year out of cells K1 & K2. The result is "January 2019". I would like to have the result be "JANUARY 2019". Is there a way to do this in the same cell by imbedding the formulas? I've tried several solutions I thought would work and always seem to get some kind of error message. Thanks in advance!

3 Replies
Try this formula:
=UPPER(TEXT(DATE(K1,K2,1),”mmmm yyyy”))
That did it! Explains one of the error messages I was getting as well. Thank you Twifoo!
I’m glad to hear that!
Related Conversations
Balanced Scorecard Sliding Scale formula problem
Will_Sarty01 in Excel on
8 Replies
Formulas combined with text
MynKapteinu83 in Office 365 on
2 Replies
omputing on limited values
Carlos Monssen in Excel on
0 Replies