1. EXTRACT A SPECIFIC WORD FROM CELLS AND COUNT =COUNTIF(A1:A6,"*sap*") 2. SARAVANA KUMAR =SARAVANA & KUMAR 3. TEXT TO COLUMN SPLIT THE DETAILS 4. FILL Select and pull the row width give the justify 5. BOOK RACK ALLOCATION =IF(COUNT(SEARCH("OPERATING SYS",A16898)),"R1","") 6. FIND THE UPPER CASE AND LOWER CASE SENTENCES =EXACT(A1,UPPER(A1)) =EXACT(A1,lower(A1)) =EXACT(B1,PROPER(B1)) or =SUBSTITUTE(B1,PROPER(B1),"x...