This tutorial shows how to create a custom Access Excel VBA custom Function to delimit text with the help of VBA "Split" Function instead of "Text to Columns". Delimit text in Excel (non-VBA) In Excel worksheet, there is a function called "Text to Columns" (Data > Text to Columns) to separate a text by delimiter. For example, Cell A1 contains "a,b,c" and after split by comma, A1 contains "a...

 What does VBA Excel Split Function do? VBA Excel Split Function separates a text by delimiter into an array, for example, you can split a text a;b;c;d into array {a,b,c,d}, afterwards you can get the desired array item (starting from 0). Split Function is similar to the action of "Text to Columns". Syntax of VBA Excel Split Function Split(text,[delimiter],[limit],[compare]) text text t...

What is Excel EDATE Function? Excel EDATE Function is to add (or subtract) specified months to a date. For example, adding 2 months to Jan 14, 2015 would be Mar 14, 2015. Syntax of EDATE EDATE(start_date, months) start_date A date to add months to months Positive integer to indicate to add month to start_date, negative to indicate subtraction By default, a Cell Format is "G...

This Excel tutorial explains how to use Excel Lookup Function and how to look up multiple criteria. You may also want to read: Excel Vlookup second matched value or specific occurence Excel Lookup Function lookup multiple criteria not in the first column Excel lookup partial text using Vlookup with Wildcard Excel Lookup Function - lookup multiple criteria Excel Lookup Function is  to...

Excel Lookup Function lookup multiple criteria not in first column In this tutorial, I will explain how to use Excel Lookup Function to lookup multiple criteria while the lookup value is not in first column of lookup range. The reason for writing this article is that Vlookup can only lookup one criteria and lookup value must be in the first column of lookup table. You can also use SUMPRODUCT...

Excel SumProduct lookup multiple criteria not in first column In this tutorial, I will explain how to use Excel SumProduct Function to lookup multiple criteria while the lookup value is not in first column of lookup range. The reason for writing this article is that Vlookup can only lookup one criteria and lookup value must be in the first column of lookup table. You can also use Lookup Func...

Excel Function add year month day hour minute second to date In this tutorial, I will show how to use Excel Function to: - add year to date - add month to date - add day to date - add hour to date - add minute to date - add second to date I recommend you to read my previous tutorial to understand the concept of time serial. In the following examples, I will assume A1 conta...

This tutorial shows a custom Access Excel VBA Function that can check prime number, the Function returns TRUE or FALSE. Access Excel VBA Check Prime Number using custom Function In this tutorial, I will show a custom Access Excel Function that can check prime number, returning TRUE or FALSE. Prime number is an integer that can only be divided by 1 or itself (without remainder). Below are some ex...

This tutorial explains how to use Excel VBA to refresh all Pivot Table or Pivot Cache, and difference between PivotCache.Refresh and PivotTable.RefreshTable You may also want to read: Excel VBA refresh closed workbook Excel automatically refresh pivot table Excel VBA refresh all Pivot Table or Pivot Cache Understanding difference between Pivot Table and Pivot Cache To start with this t...

This Excel tutorial shows how to use custom VBA Excel Function to sort data in ascending order instead of using Filter. You may also want to read Sort data using custom Function by assigning number to Text Sort data using Range Sort Method Sort data using Table AutoFilter Sort data using Worksheet AutoFilter Use VBA Excel Function to sort data in ascending order In this tutorial...