Find cells with certain characters in it [Closed]

Report
-
 Grings -
Hello,

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.

Thanks.

1 reply


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?

Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!