Hello
First things first, I am so grateful to have access to a forum where I can ask questions on Excel?. I am a bit of an Excel virgin - I have been around the block many times but only ever got to first base, never really got into the saucy stuff - this is my first proper foray into the subject of functions, so if you could go slow with me I would be grateful!!
i am (trying to) creating an excel function. The cell, let's call it D5, contains a full sentence of words. I want to create a function that detects the word "work", or "job", or "furlough" in that sentence. If it finds any of those words within the sentence I want it to print the word "employment".
THe formula/function i have created only detects the word "work" if it's the only word in the cell.
Here is my wholly inadequate function
:
=IF(K2="work","EMPLOYMENT") - its not doing what i want it to do!!!
My question is - where am I going wrong? Is the IF function the wrong function? Is there a way of Excel finding the word "work" in amongst the other words? If so could you help me construct it?
Thanks for the help guys!
Dolcevita
First things first, I am so grateful to have access to a forum where I can ask questions on Excel?. I am a bit of an Excel virgin - I have been around the block many times but only ever got to first base, never really got into the saucy stuff - this is my first proper foray into the subject of functions, so if you could go slow with me I would be grateful!!
i am (trying to) creating an excel function. The cell, let's call it D5, contains a full sentence of words. I want to create a function that detects the word "work", or "job", or "furlough" in that sentence. If it finds any of those words within the sentence I want it to print the word "employment".
THe formula/function i have created only detects the word "work" if it's the only word in the cell.
Here is my wholly inadequate function
:=IF(K2="work","EMPLOYMENT") - its not doing what i want it to do!!!
My question is - where am I going wrong? Is the IF function the wrong function? Is there a way of Excel finding the word "work" in amongst the other words? If so could you help me construct it?
Thanks for the help guys!
Dolcevita
