Excel VBA ASC Function to get ASCII value of text

This page explains how to use Excel VBA ASCFunction to get ASCII value of a text, and how to check if a text contains an alphabet, number or symbol What is Excel VBA ASC Function? Excel VBA ASC Function returns the ASCII value of the first character in a text. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many ol...
Read More

Excel VBA LEN Function to measure length of text

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

Access Excel VBA MID Function to extract substring

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

Excel VBA INSTR Function

This Excel tutorial explains how to use Excel INSTR Function for VBA, and explain difference among vbUseCompareOption, vbBinaryCompare and vbTextCompare. Excel VBA INSTR Function Excel INSTR function is used to search a substring (part of the string) within a string and return the position of the first occurrence. For example, in the string "FinanceDepartment", the substring "Department" can be found at 8th position within "FinanceDepartment", the function will return number "8". If we...
Read More

Excel VBA Round Function and custom Round Function

This tutorial explains difference between Excel VBA Round Function and Excel worksheet Round Function, and create a custom Excel Round Function. Excel VBA Round Function and custom Round Function Excel VBA Round Function is completely different from Excel worksheet Round Function. For Excel spreadsheet Round Function, if decimal part is >=0.5, the integer rounds up, otherwise the integer rounds down. For Excel VBA Round Function, as well as Access VBA, the Round Function uses "Round t...
Read More