Access Excel remove text in brackets

Access Excel remove text in brackets
This Access Excel VBA tutorial explains how to remove text in brackets using custom Function. You may also want to read: Change text color in brackets Extract text in brackets Access Excel remove text in brackets I was inspired to create this post because the HR system I am using (Workday) is very annoying, some data fields are actually a combination of two different fields, the additio...
More

Excel VBA change partial text color in Cell

Excel VBA change partial text color in Cell
This Excel VBA tutorial explains how to change partial text color in a Cell using Macro. You may also want to read: Access Excel remove text in brackets Change partial text color in spreadsheet In Excel spreadsheet, you can change part of the text in a Cell by highlighting the text and then change the font color. Suppose you want to change the text World in Cell A1 to red color. First...
More

Access Excel VBA Array

Access Excel VBA Array
This VBA tutorial explains how to create and use VBA Array in Access and Excel VBA. Access Excel VBA Array In Excel worksheet, you can convert a formula arguments to Array by pressing CTRL+SHIFT+ENTER, click here to see example. In VBA, Array is a variable that can store multiple data of the same data type. There are two types of Array in VBA One-dimensional Array Two-dimensional A...
More

Excel MOD Function to get remainder

Excel MOD Function to get remainder
Posted on
This Excel tutorial explains how to use Excel MOD Function to get remainder in division. Excel MOD Function to get remainder In Excel worksheet, you can calculate quotient by a division using operator / .  However chances are you need to calculate the quotient as well as reminder. Excel MOD Function calculate the remainder. Syntax of Excel MOD Function MOD(number, divisor) Number The n...
More

Access Excel INT Function to get the integer of number

Access Excel INT Function to get the integer of number
Posted on
This Access / Excel tutorial explains how to use INT Function to get the integer part of a number. Access Excel INT Function to get the integer of number When you have a number with decimal places, you can separate the number into integer part using INT Function, and then work around to get the decimal part. INT Function can be used in Access and Excel, and also VBA. Syntax of INT Function INT...
More

Excel Days360 Function to calculate day difference

Excel Days360 Function to calculate day difference
This Excel tutorial explains how to use Excel Days360 function to calculate day difference between two dates. Excel Days360 Function You can easily calculate the number of days between two dates by a simple deduction using Excel formula, however when you try to calculate the number of years between two dates, most people simply divide the day difference by 365. However, because every month has d...
More

Excel VBA convert cell contents into table

Excel VBA convert cell contents into table
Posted on
This Excel VBA tutorial explains how to convert cell contents into table using Exel VBA. Excel VBA convert cell contents into table Yesterday when I tried to copy a table from a website to Excel, all the table contents are pasted into a single cell instead of copying the whole table. I believe there are workarounds to copy table but since this is an Excel blog, I want to write a Macro to convert...
More

Excel currency converter template

Excel currency converter template
This Excel tutorial explains how to create a currency converter template to convert one currency to another currency. Excel currency converter template In my previous post, I have demonstrated how to get currency exchange rate using VBA custom function and get the exchange rate via website. However I didn't make a convenient currency converter template to convert one currency to many different c...
More

Excel world time converter template

Excel world time converter template
This Excel tutorial explains how to create a world time converter template in Excel. Excel world time converter template There are a lot of websites that allow you to enter time of one country and convert to time of another country, or even convert to time of multiple countries. These websites work absolutely fine with the exception that they do not allow you to save your searched result. It is ...
More

Excel automatically refresh pivot table

Excel automatically refresh pivot table
Posted on
This Excel tutorial explains how to automatically refresh pivot table using Macro / VBA and Pivot Table Options. Excel automatically refresh pivot table You may have a pivot table that links to data in the same workbook or external data, and you may want to refresh pivot table automatically in order to see the most updated data. In this tutorial I will show several ways to automatically refresh ...
More