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.

Find cells with certain characters in it
Characters in dinosaur game - Guide
Special characters facebook - Guide
Excel macro to create new sheet based on value in cells - Guide
Please check your phone for a text message with your code. your code is 6 characters long. - Facebook Forum
Which example represents cell data with the date format applied to it? - Excel Forum

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.

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

Similar discussions

help me to add particular cells

Hi Guys how to create an account for facebook with my company em

Condition formatting on changing cell color based on another cel

Comparing columns and returning value

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!