Is it possible to use the LEFT and PROPER function in the same formula?
For example I want to grab the cell C3 that has the words 'BASIC SKILLS' in
it. I only want to display the left part of the cell and in proper case. So
in my resulting cell (C5) the result would be 'Basic.'
I can't seem to do this in one formula.

I would appreciate any help.
Sam