Change part of string to lower

P

Pat

Here is an example of what i would like a formula to carry out:

before
Amur Pink
after
Amur pink

before
Apple-bearing Sage
after
Apple-bearing sage

before
Armenain Yard Long Cucumb
after
Armenain yard long cucumb

Thank you if you can help
Pat
 
P

Pete_UK

Assuming your string is in A1, try this formula:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

Hope this helps.

Pete
 
V

vezerid

Pat,
if A2 holds the phrase, use the following:
IF(ISNUMBER(FIND(" ",A2)),PROPER(LEFT(A2,FIND("
",A2)))&LOWER(MID(A2,FIND(" ",A2),LEN(A2))),PROPER(A2))

HTH
Kostis Vezerides
 
Top