single cell counting

[jimblimm]

In a2 i have a for digit number
0234

I am trying to create a formula that will tell me if the four digit number in a2 has a "2" inside it.
Answer in a3

Also a formula that will count how many 2 are inside the single cell

 

[Andrew Poulsom]

Try eg:

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="2"))

 

[martindwilson]

=isnumber(find(2,a1))
and
=len(a1)-len(substitute(a1,2,""))

 

[jimblimm]

Using same concept, is there a way to make a formula show how many of the digits in the cell are high digits
Greater than or equal to 5,
And low digits less than or equal to 4

example number

4532

I want the display to read

"1-High 3-Low"

And also in another cell display

The even odd count

Even number
02468

Odd 13579

Answer

"2-Odd 2-Even"

But if the number are all even or all odd

"All Even", "All Odd"

or all high and low

"All High, "All Low"

 

[jimblimm]

Using same concept, is there a way to make a formula show how many of the digits in the cell are high digits
Greater than or equal to 5,
And low digits less than or equal to 4

example number

4532

I want the display to read

"1-High 3-Low"

And also in another cell display

The even odd count

Even number
02468

Odd 13579

Answer

"2-Odd 2-Even"

But if the number are all even or all odd

"All Even", "All Odd"

or all high and low

"All High, "All Low"