Here is an example column of data:
COLUMN A:
Aids Healthcare Foundation Disease Managment of Florida Inc.
Alliance for Childhood Diseases
Alzheimers Disease & Related Disorders Association
I'd like to see the results of Column B to be:
Foundation
Childhood
Alzheimers
So the function is finding the word directly to the left of "Disease"
Bookmarks