Find cells with certain characters in it

Grings - Nov 13, 2009 at 04:27 AM
 Grings - Nov 13, 2009 at 04:51 AM

I am trying to get an if statement together that basically says if a certain character is in a cell then set to true, if not set to false. The IF statement is not the problem but the how to get it to match certain characters (in my example 08 in long line of numbers in a cell).

Any ideas? Need this fairly urgently, any help greatly appreciated.


1 reply

Blocked Profile
Nov 13, 2009 at 04:45 AM
Dear Grings,

Please make use of the following sample to solve the trouble that you are

actually experiencing:

Enter the following text in cell A1: Sum ?

Enter the following formula in cell B2: =FIND("?",A1)>0.

Then select the particular cells.

This will be the solution to the actual difficulty.

Thanks in advance.
Thanks for your reply.

Just realised some more complication to it.

I only wish to search the first two characters of each cell. So in my example the if statement is positive if the first two characters of the cell are 08. If 08 appears anywhere else in the cell i want the formula to ignore it and providing the first two characters are not 08 bring back a negative result to the if statement.

Is this possible?