Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Format first letter in uppercase
Message
De
29/06/2020 15:26:39
 
 
À
27/06/2020 21:29:16
Information générale
Forum:
Office 365
Catégorie:
Excel
Divers
Thread ID:
01674986
Message ID:
01675048
Vues:
63
>I have a custom format such as:
>
>[$-fr-CA]mmmm yyyy
>
>I need the first letter of the month to be uppercased?
>
>=REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1)))
>
>You'll have to run this

Thanks, but I have this in that cell:

=EDATE(A1,A48)

I am trying to find how to incorporate the REPLACE fonction in that one.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform