Access Excel VBA extract number from text or extract alphabet

Posted on February 8, 2015September 4, 2017 by Wyman W

This tutorial shows several Access Excel VBA custom functions to extract number from text, extract alphabet from text, extract symbols from text Excel Access VBA extract percentage from text Excel Extract Time from Date Time or Extract Date Access Excel extract file name from file path Access Excel VBA extract number from text or extract alphabet from text In this article, I will show a list of custom Functions to perform the following tasks. - Check if a text contains any alphabet, ...

Access Excel Function HKID Check Digit (last digit)

Posted on January 27, 2015October 13, 2015 by Wyman W

This Excel tutorial explains the algorithm of HKID Check Digit (last digit) and provide a custom Access Excel VBA Function to verify the Check Digit. (香港身份証最後號碼) You may also want to read: Access Excel Generate random HKID Hong Kong ID card number HKID Check Digit Hong Kong ID card number has a last digit with bracket called "Check Digit". Check Digit is a number to verify if the previous number and alphabet are correct. By understanding the algorithm of calculating Check Digit, you ...

Excel VBA Round Function and custom Round Function

Posted on December 26, 2014March 7, 2015 by Wyman W

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

Custom VBA Excel Access Networkdays Function

Posted on December 4, 2014March 7, 2015 by Wyman W

This tutorial explains how to create a custom Excel Access Networkdays Function to simulate Excel Networkdays Function, exclude holiday and weekend Why do we need Access Networkdays Function? As of Access 2013 version, there is no Access Networkdays Function available, the function is only available in Excel all versions. In Excel , Networkdays Function is used to calculate the number of "net working days" between two days, excluding Saturday and Sunday, and include both start date and end ...