Forum Discussion
Need to have blank cell if there is specific value in my cell
Hi team, Lets say I have a dataset with the following values. I want to automatically empty the cell in cell 2 or replace with 0 while the remaining cells will show 0.5 & 9.5 accordingly. I'm op...
=TRIM(IF(ISNUMBER(SEARCH("Rejected",A1)),"",MID(A1,FIND("-",A1)+1,LEN(A1)-1-FIND("-",A1))))Does this return the intended result? The cells which contain "Rejected" are cleared and the values from the other cells are extracted.