Maybe

=PROPER(LEFT(A1,FIND(" ",A1)))

Mike

"Sam" wrote:

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