A B C D E 1 2 3 4 Data Kazam BD123 Formula Description (Result) =IF(ISNUMBER(SEARCH("m",A2)),"OK", "Not OK") Checks to see if A2 contain the letter m (OK) =ISNUMBER(SEARCH("BD",A3)) Checks to see if A3 contains BD (TRUE) =IF(ISNUMBER(FIND("M",A2)),"OK", "Not OK") Checks to see if A2...

Data Kazam BD123 Formula Description (Result) =IF(ISNUMBER(FIND("m",A2)),"OK", "Not OK") Checks to see if A2 contain the letter m (OK) =ISNUMBER(FIND("BD",A3)) Checks to see if A3 contains BD (TRUE)

Data Kazam Formula Description =IF(A2="Kazam","OK", "Not OK") Checks to see if A2 is Kazam (OK) =IF(A2="Raza", TRUE, FALSE) Checks to see if A2 is Raza (FALSE)

Data Kazam 123 Formula Result Description =ISTEXT(A2) TRUE Checks to see if cell A2 has text (TRUE) =ISTEXT(A3) FALSE Checks to see if cell A3 has text (FALSE)

Name kazam RAZA Formula Result Description =UPPER(A2) KAZAM RAZA Changes text to all UPPERCASE =LOWER(A2) kazam raza Changes text to all lowercase =PROPER(A2) Kazam Raza Changes text to Title Case

New worksheet functions Microsoft Excel 2013 Preview adds about fifty new worksheet functions for compatibility with the Open Document Format (ODF 1.2). And you can now use web service functions (in the Web functions category) to anonymously access REST Web services. Of special note is the...

Excel is one of the most popular spreadsheet software used by professionals in the world. In my trainings many people ask me what is advance excel? and they come to attend my training only to see that what are the advance tools in excel that make it advance? I am always happy to answer all type of...