SOLVED

Capitalise Month as text in concatenated field

%3CLINGO-SUB%20id%3D%22lingo-sub-2773892%22%20slang%3D%22en-US%22%3ECapitalise%20Month%20as%20text%20in%20concatenated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773892%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20unique%20reference%20field%20created%20by%20concatenating%20a%20date%20field%20and%20a%20text%20field%2C%20but%20would%20like%20the%20month%20to%20print%20in%20capitals.%3C%2FP%3E%3CP%3EI%20have%20this%20formula%20but%20the%20month%20won't%20capitalise%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%22CR%22%26amp%3BTEXT(%5BReview%20Date%5D%2CUPPER(%22ddMMM%22))%26amp%3B%5BCredit%20Ref%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20gives%20an%20output%20such%20as%20%22CR21Sep12345678%22%20%2C%20but%20I%20want%20%22CR21SEP12345678%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2773892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2774120%22%20slang%3D%22en-US%22%3ERe%3A%20Capitalise%20Month%20as%20text%20in%20concatenated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1062690%22%20target%3D%22_blank%22%3E%40markikav1955%3C%2FA%3E%26nbsp%3B%20the%20formula%20should%20be%20%3D%22CR%22%26amp%3BUPPER(TEXT(%5BReview%20Date%5D%2C%22DDMMM%22))%26amp%3B%5BCredit%20Ref%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi Community 

I have a unique reference field created by concatenating a date field and a text field, but would like the month to print in capitals.

I have this formula but the month won't capitalise?

 

="CR"&TEXT([Review Date],UPPER("ddMMM"))&[Credit Ref]

 

this gives an output such as "CR21Sep12345678" , but I want "CR21SEP12345678"

 

Thanks! 

2 Replies
best response confirmed by markikav1955 (Contributor)
Solution

@markikav1955  the formula should be ="CR"&UPPER(TEXT([Review Date],"DDMMM"))&[Credit Ref]

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thank you very much Rob!