Is there a way to convert lowercase to initial uppercase in Excel?
But that changes everything, right? Now, nothing seems to work on my Swedish setup.
You need to use the PROPER function:
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