Calc capitalize first letter of every new input

I have this huge list of names. 1 name goes into a 1 cell, I need to give my pinky a rest and looking for a way for Libre Calc to automatically capitalize first letter of every name.

how can I do this? seems like an obvious thing but navigating through obvious places it should be couldn’t find anything.

Perhaps it will help you


Wow, thnx.

Can’t believe I missed it, so embarrassing…

That is obsolete now, newly it is in Text → Change case