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

# Book 1 – Microsoft Excel

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

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

# Excel MOD Function to get remainder

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

# Access Excel INT Function to get the integer of number

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

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

# Excel VBA convert cell contents into table

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

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

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

# Excel automatically refresh pivot table

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