Change part of string to lower
 

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

Change part of string to lower
 

Assuming your string is in A1, try this formula:

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

Hope this helps.

Pete

Pat wrote:
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

Change part of string to lower
 

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