Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make left side stay still and right side can move left to r | Excel Discussion (Misc queries) | |||
My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
worksheet is right-to-left but i want left-to-right...? | New Users to Excel | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) |