Hello friends,
I have a question about finding the word "pear" in a string
I need to write the result in column C ...
In column A there is fruit with "Pear"
Column B contains other fruit, but also "Pear"
If there is a pear in column B, then write the result without "Pear" in column C.
The formula works if there is a Pear in column B, but when I add more fruit, it doesn't work. The result should be cherry, grapes
Please how to edit the formula?
Formula in C1: =SUBSTITUTE(SUBSTITUTE(A1;B1&", ";"");B1;"")
I have a question about finding the word "pear" in a string
I need to write the result in column C ...
In column A there is fruit with "Pear"
Column B contains other fruit, but also "Pear"
If there is a pear in column B, then write the result without "Pear" in column C.
The formula works if there is a Pear in column B, but when I add more fruit, it doesn't work. The result should be cherry, grapes
Please how to edit the formula?
Formula in C1: =SUBSTITUTE(SUBSTITUTE(A1;B1&", ";"");B1;"")
duplicity (version 1).xlsb | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | apple, pear, cherry, grapes | pear | apple, cherry, grapes | ||
2 | apple, pear, cherry, grapes | pear, apple, banana | apple, pear, cherry, grapes | ||
Hárok6 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C2 | C1 | =SUBSTITUTE(SUBSTITUTE(A1,B1&", ",""),B1,"") |