Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

Say I have an Excel sheet of 100 records where there are 3 columns A, B and C.

The requirement is I have to get all the rows from column C if the text in column C matches with SQL Server.

Here the text SQL Server is in different formats SQL Server,sql Server,sql server

I used the command =IF(ISERROR(FIND("SQL Server", C2)), 1, 0) to find the matching rows in column C.

If a match is found it returns 0 otherwise it returns 1.

Now the problem is it is returning 1 for strings like sql server and sql Server.

How do I make the FIND command case insensitive?

share|improve this question

migrated from stackoverflow.com Sep 17 '11 at 11:25

1 Answer

up vote 2 down vote accepted 
=IF(ISERROR(FIND("sql server",LOWER(C2))),1,0)
share|improve this answer
Thanks Silx also I tried this way =IF(ISERROR(SEARCH("sql server",LOWER(C2))),1,0) is this correct way? I could see all the field values matching with sql server are resulting 0 irrespective of the case. – user840963 Sep 16 '11 at 21:37
2  
FIND is case sensitive, SEARCH is not (and can use wild cards) so you could use =IF(ISERROR(SEARCH("SQL Server",C2)),1,0) – chris neilsen Sep 16 '11 at 22:16
Thanks chris.I got the answer doing this way. – user840963 Sep 16 '11 at 22:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.