Before canceling spaces (cell K18), how can all of the first letter of each word be be changed to uppercase (K17) ?
1 Like
Sorry, I forgot this formula, PROPER
.
Cell K18
=SUBSTITUTE(PROPER(K16)," ","")