how to split text in excel
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