I'll rephrase this and you tell me whether I said it right: Somewhere in an
Excel workbook you have a cell that contains either of these two text
strings. You want some way of detecting whether the text string says "Supply
& Fit" or "Supply Only", and pulls a value from either of two cells (you made
them both A1 in your example but I suppose you mean two DIFFERENT cells)
depending on that distinction. And you warn us that the place where you put
asterists could be a number of different text values, not all of the same
length -- that is, the text could read "We have pleasure in submitting our
quotation for a Supply & Fit in a low and high Wind Zone as per NZS 3604 as
below:" or "We have pleasure in submitting our quotation for a Supply & Fit
in a medium Wind Zone as per NZS 3604 as below:". Right?

If so, the length of the wind-zone type doesn't matter; the very simplest
way to do it, it seems to me, is to look at the 59th character in that
sentence; if it's "&" then it's "Supply & Fit", and if it's "O" then it's
"Supply Only". One way of doing that would be a formula saying
=IF(MID(D4,59,1)="&",A1,A2). This says "if the 59th character of D4 is "&",
plus A1 in here; otherwise plug A2 in here". Will that do?

--- "Jeffrey" wrote:
I have two sentence, see below: and I would like to reflect respective
dollar value for these statements. If the sentence has "supply & fit"
then it will reflect a supply and price in cell A1 for example. of if
the sentece has "supply only" then it will reflect the supply only
price in cell A1. Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).

Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:

Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below: