I'm trying to produce a form which uses data & text from another sheet. I
have not been able to get Excel to find specific text in a string while
ignoring any other text contained in the string. e.g. "Payment for goods"
Find "payment" but ignore "for goods". Then copy the relevant data I need
from other cells. I have only been able to find "payment" if it's the only
text in the cell. Any help would be appreciated.