Calc: Formula for changing the first letter of each word to be uppercase

lonk · February 11, 2021, 2:23am

image description

Before canceling spaces (cell K18), how can all of the first letter of each word be be changed to uppercase (K17) ?

lonk · February 11, 2021, 2:31am

Sorry, I forgot this formula, PROPER.

Cell K18 =SUBSTITUTE(PROPER(K16)," ","")