=PROPER(LEFT(C3,FIND(" ",C3)-1))

if it is always the first word separated by a space

--


Regards,


Peo Sjoblom

"Sam" wrote in message
...
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