Search for specific text

[arvarr]

Hi
How do i search for specific text in a formula but not case sensitive?

Example:

A1 = Exclusive
A2 = Ex-Gratia

Using the search function in the formula, if i wish to search for Ex-Gratia, the results will also search and give results for Exclusive

Thanks.

 

[mintjulep]

IF(sense <= 0 , #No_Replies)

 

[Deniall]

The question you start your post with can be answered with, for example,
=IF(UPPER(Cell-Address)="HELLO", "Yep", "Nup")

The statement you finish your post with makes no sense to me (nor to mintjulep apparently).

 

[combo]

For partial search, SEARCH function is not case sensitive (in opposite to FIND).

combo

 

[sxschech]

Do you mean to search for cells where the first two letters begin with Ex? For that can use Left

=IF(LEFT(A2,2)="Ex","Has Ex","")