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

jugnoo promo code for first ride jugnoo free ride code To get free ride Jugnoo promo code you have flow to following the below steps:- Download Jugnoo app from  Google play store After Downloading open the app and sign up using your details During the SINUP Please Fill l the code   RAJEEV431176  Now you have successfully Get RS 100 OR 50 for Free Ride in Jugnoo. jugnoo free ride coupon,  coupon code for jugnoo Thanks 

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") 

updating two tables in a single query in mysql UPDATE  tb1 , tb2  SET  tb1.name= 'new name', tb2.name = 'tb2 name'   WHERE   tb1.id = '1'  AND  tb2.id = '5'