Lowercase to uppercase

[karinelisabet14]

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

[#2]

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

[#3]

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

[#4]

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