Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
EXCEL - How to use the IF function to find a particular word in a STRING of text ?
Hi so i am creating an excel function. The cell D5 contains a full sentence of words. I want to create a function that detects the word "work" in that sentence. If it finds that word within the sentence I want it to print the word "employment".
THe formula/function i have created only detects the word "work" if its the only word in the cell.
Here is my function:
=IF(K2="work","EMPLOYMENT") - its not doing what i want it to do!!!
My question is - Is there a way of Excel finding the word "work" in amongst the other words?
3 Answers
- expletive_xomLv 72 weeks ago
to find text somewhere in a cell...you would use the FIND() or SEARCH() function.
Problem with those functions are if they dont find anything...then they will throw an error. so stick it in an ISNUMBER() to error correct.
=IF(ISNUMBER(FIND("work",K2)), "Employment","")
let me know if this helps
- D.E.B.S.Lv 72 weeks ago
https://exceljet.net/formula/if-cell-contains
In your example, K2 does not equal "work", it only contains "work". The link above tells you how to get a Contains functionality in excel.
