Proper() will cap the 1st letter of every word, not just the 1st word

perhaps something like this?
=SUBSTITUTE(A2,LEFT(A2,1),UPPER(LEFT(A2,1)))