View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 122
Default Bring back lowercase values

Anyone got a solution to return only lowercase vaues in a string. Excluding
where an x is on its own.


Example1
Abelia x grandiflora Francis Mason
Returns
grandiflora

Example2
Abies balsamea f. hudsonia
Returns
balsamea f. hudsonia

Example3
Abutilon vitifolium var. Album
Returns
vitifolium var.

Example4
Abies nordmanniana Golden Spreader
Returns
nordmanniana


Much appreciate if you can help.

Pat