Forum Discussion
HOW TO: "If cell contains specific text display the immediate next word after it"
I have an excel file with each individual cell filled with data as it follows: Alejandro - GREEN Daniel - RED Sebastian - BLUE What I have been trying to do is to use a formula to extract the ...
Alejandro, you leave some room for interpretation because you did not provide a sample file with the desired results.
My guess woulds be:
=IF(COUNTIFS(A1,"*Daniel*"),SUBSTITUTE(A1,"Daniel - ",""),"No")
sorry i am literally new to this site, i attached the file to the original post just now
Because of my mistake the formula you provided did not match, sorry :/
Because of my mistake the formula you provided did not match, sorry :/