LEFT and PROPER
 

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

LEFT and PROPER
 

=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

LEFT and PROPER
 

How about =PROPER(LEFT(A1,5))
Or =PROPER(LEFT(A2,FIND(" ",A1)-1))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

LEFT and PROPER
 

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

LEFT and PROPER
 

This did the trick. Thanks a lot.

Sam

"Mike H" wrote:

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

LEFT and PROPER
 

Your welcome


"Sam" wrote:

This did the trick. Thanks a lot.

Sam

"Mike H" wrote:

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