Home

Lowercase to uppercase

%3CLINGO-SUB%20id%3D%22lingo-sub-359641%22%20slang%3D%22en-US%22%3ELowercase%20to%20uppercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359641%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20convert%20lowercase%20to%20initial%20uppercase%20in%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359641%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-359939%22%20slang%3D%22en-US%22%3ERe%3A%20Lowercase%20to%20uppercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359939%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FPROPER-function-52A5A283-E8B2-49BE-8506-B2887B889F94%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EPROPER%3C%2FA%3E%20function%3A%3C%2FP%3E%3CPRE%3E%3DPROPER(A1)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20a%20localized%20version%20of%20Excel%20in%20the%20Swedish%26nbsp%3Blanguage%2C%20I%20think%20the%20PROPER%20function%20called%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fsv-se%2Farticle%2Ffunktionen-initial-52a5a283-e8b2-49be-8506-b2887b889f94%3Fui%3Dsv-SE%26amp%3Brs%3Dsv-SE%26amp%3Bad%3DSE%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EINITIAL%3C%2FA%3E%20in%20this%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359649%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Lowercase%20to%20uppercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359649%22%20slang%3D%22en-US%22%3E%3CP%3EBut%20that%20changes%20everything%2C%20right%3F%20Now%2C%20nothing%20seems%20to%20work%20on%20my%20Swedish%20setup.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359643%22%20slang%3D%22en-US%22%3ERE%3A%20Lowercase%20to%20uppercase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359643%22%20slang%3D%22en-US%22%3ESure%2C%20use%20the%20upper()%20function%2C%20eg%20%3Dupper(A1)%3C%2FLINGO-BODY%3E
karinelisabet14
New Contributor

Is there a way to convert lowercase to initial uppercase in Excel?

3 Replies
Sure, use the upper() function, eg =upper(A1)

But that changes everything, right? Now, nothing seems to work on my Swedish setup.

Hi,

 

You need to use the PROPER function:

=PROPER(A1)

 

If you have a localized version of Excel in the Swedish language, I think the PROPER function called INITIAL in this version.

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies