Excel MID Function to extract substring

Posted on February 4, 2015December 25, 2016 by Wyman W

This Excel tutorial explains how to use Excel MID Function to extract substring from a string, and use with FIND and SEARCH and LEN Function. You may also want to read: Extract text in brackets Remove text in brackets Excel MID Function MID Function is quite similar to LEFT Function and RIGHT Function, where RIGHT Function extracts a substring on the right, LEFT Function extracts a substring on the left, while MID extracts a substring in the middle of the string. MID Function is co...

Excel Find Function

Posted on January 21, 2015December 25, 2016 by Wyman W

This Excel tutorial explains how to use Excel FIND Function for Excel worksheet, and also explains the differences between INSTR and SEARCH function. You may also want to read: Extract text in brackets Remove text in brackets Excel Find Function Excel Find function is used to search a substring (part of the string) within a string and return the position of the first occurrence, note that Excel Find function is case sensitive. Excel Search function is very similar to Find functi...