Check to see if any characters are the same.

[DouglasWicker]

Hi all,

I would like an if function which would check to see if a string of numbers has any of the same characters as a variable.

I.e. if my variable is 35, I'd like the if function to be true if the cell contains either 3 or 5.

Thanks

[davsth]

If your cells just contain 3 or 5
=ISNUMBER(SEARCH(a1,a2,1))
=ISNUMBER(SEARCH(cell with 3 or 5,cell with 35,1))

[mehmetcik]

Please Login or Register  to view this content.

Tested using S = abcd3hgg, V = 35.

This will support any length of string or variable.

[DouglasWicker]

If your cells just contain 3 or 5
=ISNUMBER(SEARCH(a1,a2,1))
=ISNUMBER(SEARCH(cell with 3 or 5,cell with 35,1))

Thanks for the help

The variable could be 235.

If the cell has a 2, a 3 or a 5 anywhere in it than I need a value of true. Would this work?

[DouglasWicker]

Please Login or Register  to view this content.

Tested using S = abcd3hgg, V = 35.

This will support any length of string or variable.

I'll try this now, thank you.

[Rick Rothstein]

Here is a UDF (user defined function) that will do what you asked for...

Please Login or Register  to view this content.

[DouglasWicker]

Here is a UDF (user defined function) that will do what you asked for...

Please Login or Register  to view this content.

Thanks, though i still don't properly know how to use a function in a sub

[Rick Rothstein]

I just thought of a way to make the function you want without using any loops...

Please Login or Register  to view this content.

Note: This function assumes the first argument is a number composed of all digits only.

[Rick Rothstein]

Thanks, though i still don't properly know how to use a function in a sub

You would use any of the posted functions the same way you would use a built-in function... pass the arguments into it and do something with the result. For example...

If NumInNum(123456, 35) Then
....
End If

or...

MsgBox NumInNum(123456, 35)

or...

SomeBooleanVariable = NumInNum(123456, 35)

[mehmetcik]

Save the function in a Macro Module.

Type something like abcde4h3fgg in A1
Type =VarF(A1, 235) in any other cell.