Excel VBA LEN Function to measure length of text

Posted on February 6, 2015December 18, 2016 by Wyman W

This Excel VBA tutorial explains how to use LEN Function to measure length of text. Excel VBA LEN Function Excel VBA LEN Function is to measure the length of text, to be more precise, the number of characters in a text. LEN Function is most useful as a tool for data validation where length of text always have limit in a system. LEN Function is also commonly used in conjunction with other functions: LEFT Function - extract a substring on the left RIGHT Function - extract a substri...

Access Excel VBA MID Function to extract substring

Posted on February 4, 2015September 27, 2016 by Wyman W

This tutorial explains how to use MID Function to extract substring from a string in Excel / Access VBA Excel / Access VBA 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 commonly used with INSTR Function, which returns the position of the string (In Excel worksheet, use Search Func...

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...

Excel Search Function

Posted on January 21, 2015July 26, 2018 by Wyman W

This Excel tutorial explains the Excel Search Function for Excel worksheet, and also explains the differences between INSTR and FIND function. Excel Search Function Excel Search function allows Wildcard to search a substring (part of the string) within a string and return the position of the first occurrence. Excel Search Function is not case sensitive, you should consider using Excel FIND Function for case sensitive comparison, but FIND Function cannot use Wildcard. For example, ...