Technical Details and PHP Developer

How to Split String or text in excel. Formula For Result-1      =LEFT(A2, FIND("",A2,3)) A2= Cell address. 3= cut first three character Formula for Result-2 If in excel String or text is separated by any word or character than used following formula =LEFT(A2, FIND("p",A2,1)) A2= Cell address. P= separated character Text Result -1 Result -2 abpcdefg abp abp abcdpefg abc abcdp abcpdefg abc abcp abcpdefg abc abcp abcdefpg abc abcdefp apbcdefg apb ap

how to add formula in text in excel in column E ="Column B+C= "  &B1+C1&  " result" type text in invert er  comma and  and formula in  & symbol 

FORMULA :- VLOOKUP (Which Value You Want To Search , Where You Want Search value , Table Index Which Value You Want To Display , FALSE/TRUE) =VLOOKUP(D8,A2:B7,2,FALSE)

formula :- in C2   =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1) excel 2007 count unique values multiple criteria 

compare two columns in excel for differences 2007 comparing two columns in excel  =IF(A1=B1,"MATCH","NOT MATCH")