Hello,
I would like to extract specific string from a cell and based on that string would like type of different values in another cell.
Example, in cell A1 if we have 3.5 included as part of string then B1 =TEST1
In Cell A2 if we have 70 included as part of string B2=TEST2
in cell A3 if we 70/3.5 included as part of string then B3=TEST3
A1=18/18/21/26/3.5
A2=18/18/21/80/70
A3=18/18/21/26/70/3.5
Thanks.
I would like to extract specific string from a cell and based on that string would like type of different values in another cell.
Example, in cell A1 if we have 3.5 included as part of string then B1 =TEST1
In Cell A2 if we have 70 included as part of string B2=TEST2
in cell A3 if we 70/3.5 included as part of string then B3=TEST3
A1=18/18/21/26/3.5
A2=18/18/21/80/70
A3=18/18/21/26/70/3.5
Thanks.