View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 122
Default 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