How many formulas does Excel contain

Cell contains specific part of text
authormessage
help
You can freely change the rank in the profile


Posted:
Jan 20, 2009, 2:46 pm
First name:

       Version: Office 2003

Hey guys,

I need a little food for thought

I'm looking for a formula that provides me with the following:
if a cell contains a certain text module, then tell me yes or no.

Example:
in A1 it says "house cat dog"
in A2 it says "cat dog house"
in A3 it says "dog cow cat"

in B1, B2; B3 should now appear yes or no using the formula, depending on whether the word "house" appears in A1, A2, A3.

The word is always in a different place in the overall text, so that I cannot work with the left (), middle () or right () function.

does anyone have an idea how to solve the whole thing?

thank you for your help and nice greetings
help
Magic
Excel is fine and VBA could be better


Posted:
Jan 20, 2009, 2:54 pm
Call name: Michael


       Version: Office 2003

Hello help

if it can also be TRUE and FALSE:

= NOT (ISERROR (SEARCH ("House"; A1,1)))

with yes and no:

= if (NOT (ISERROR (SEARCH ("House"; A1; 1))); "yes"; "no")

greeting
Michael
_________________
You don't become a patrician if you know how things work, but if you know how people work.
(based on Terry Pratchett)
help
You can freely change the rank in the profile


Posted:
Jan 20, 2009, 7:01 pm
First name:

Gerda - guest
guest


Posted:
March 04, 2014, 4:40 pm
First name:


       Version: Office 2003

Hi, another thank you from an onlooker - had the same problem. Thanks for solving the same!

Gerda
    UpAll times are
GMT + 1 hour
You can Post in this forum.
You can Reply to posts in this forum.
You can your posts in this forum Not to edit.
You can your posts in this forum Not Clear.
You can to polls in this forum Not participate.
You can Files in this forum Not Post
You can Download files in this forum

Related topics
Forum / Topics reply author Calls last contribution
Excel formulas: cell should be colored automatically14claudy317619 Jun 2006, 00:03
guest
Excel formulas: reference to cell output formula12Patrick07052568Nov 26, 2004, 11:36 am
Arnim
Excel formulas: take parts from a cell5Yakima198023 Nov 2004, 5:06 pm
Yakima
Excel formulas: colored background of certain cells3guest286709 Nov 2004, 10:38 pm
= KB = shorty
Excel formulas: highlight cell in color12guest419205 Nov 2004, 1:25 am
Arnim
Excel formulas: values ​​from list with validation in cell1guest2516Oct 18, 2004, 3:20 pm
icke
Excel formulas: VLOOKUP, value from next cell9Dave5483Oct 11, 2004, 1:50 pm
Dave
Excel formulas: filter the last three digits from a cell ??7Ben339823 Sep 2004, 1:39 pm
guest
Excel formulas: grouping v. certain columns / cells1guest4713Sep 21, 2004, 4:41 pm
fl618
Excel formulas: Automatic color change of a cell.1Stefan 665197Aug 19, 2004, 2:51 pm
fl618
Excel formulas: Read out several numbers from a cell7coatin27337911 Aug 2004, 3:18 pm
Arnim
Excel formulas: only allow input in one cell1pkegelking164511 Aug 2004 10:42
icke