Previous Topic Next Topic

Find cells with certain characters in it

Closed
Grings - Nov 13, 2009 at 04:27 AM
 Grings - Nov 13, 2009 at 04:51 AM
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 response

Answer 1 / 1
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.
0
Grings
Nov 13, 2009 at 04:51 AM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Excel format
D -
sheryljohnson -

1 response