Useful Tips for Excel by Vivekanand Mishra Abstract Useful Tips for Excel Here are some commonly used Excel formulas, you may run into need: Extract a portion of String - Left side of a match pattern Formula: =LEFT(A1,SEARCH("MyTest",A1)-1) A1 - the cell on which value to run this formula; It can ...