Excel VBA Function - Free Excel Tutorial

How to Calculate the Average Excluding the Smallest & Highest Numbers in Excel

This post will introduce you to three methods for calculating the average of a range of numbers in Microsoft Excel, excluding the smallest and largest values. The first and second method involves using the formula, while the third method utilizes VBA code. 1. Calculate the Average Excluding the Smallest and Highest Numbers Using Formula Calculating… read more »

How to Extract First Letter from Each Word in a Cell in Excel

This post will guide you how to extract first letter from each word in a given cell in Excel. How do I extract the first letter of each word in a range of names in your current worksheet in Microsoft Excel 2013/2016. Assume that you have a range of First, Second and third names and… read more »

How to ignore Blank Cells while Concatenating cells in Excel

This post will guide you how to concatenate cells but ignore all blank cells in your worksheet in Excel. How do I concatenate cells but ignore blank cells with a formula in Excel. How to create a concatenate formula to skip blank cells with user defined function in Excel 2013/2016. Concatenating Cells but Ignore Blanks… read more »

How to Get the Maximum or Minimum Absolute Value in Excel

It is easy to find the maximum or minimum value in a batch of data in excel, but if this batch of numbers contains both positive and negative numbers, the maximum or minimum absolute value cannot be found out by basic MAX or MIN function in excel. This article will help you to solve this… read more »

How to Count Only Numbers in Bold in a Range of Cells in Excel

This post will guide you how to Count only numbers with bold style in a range of cells in Excel. How do I Count on cells with bold font within a range of cells using User defined function in Excel 2013/2016. Count  Only Numbers with Bold Font Style Assuming that you have a list of… read more »

How to Sum Only Numbers in Bold in a Range of Cells in Excel

This post will guide you how to sum only numbers with bold style in a range of cells in Excel. How do I sum on cells with bold font within a range of cells using User defined function in Excel 2013/2016. Sum Bold Numbers Assuming that you have a list of data in range B1:B6,… read more »

How to Filter Formula in Excel

This post will guide you how to filter your data with an Formula in Excel. How do I filter cells with formulas through a User defined function in Excel 2013/2016. Filter Formula Assuming that you have a list of data in range B1:B5, in which contain some text values and formulas. and you want only… read more »

How to Count Cells by Font Color in Excel

This post will guide you how to count cells by font color in Excel. How do I Count the number of cells with specific cell Font color by using a User Defined function in Excel. Count Cells by Font Color Assuming that you have a list of data in range B1:B9, in which contain some… read more »

How to Highlight Cells Containing Formulas in Excel

This post will guide you how to highlight cells in which contain formulas using Conditional Formatting feature in Excel. How do I conditionally format a cell if it contains formula using a User defined function in combination with Conditional Formatting feature in Excel 2013/2016. Method1: Highlight Cells Containing Formulas Using Defined Name Method2: Highlight Cells… read more »

How to Extract Number from Text String in Excel

This post will guide you how to extract number from a given test string in Excel. How do I extract all numbers from string using a formula in Excel. How to get all number from a given test string using user defined function in Excel. Extract Number from String with Formula Extract Number from String… read more »

How to Filter Data with Strikethrough Format in Excel

This post will guide you how to filter or delete rows with strikethrough format in your selected range of cells in Excel. How do I Filter by strikethrough formatted text with Find and Replace function in Excel 2013/2016. Or how to find cells with strike through formatting in Excel. Filter Data with Strikethrough Formatting Using… read more »

How to Convert a String into a Formula in Excel

This post will guide you how to convert a string into a formula in Excel. How do I turn test strings to a formula for calculation. Convert a String into a Formula Assuming that you have a list of data in range C1:C4, which contains text string (Actually, they are all formulas, but they are… read more »

How to Remove Duplicates in One Cell in Excel

This post will guide you how to remove duplicate characters from a text string in one cell in Excel. How do I remove duplicate words from a cell with a User Defined Function in Excel 2013/2016. Remove Duplicate Characters Remove Duplicate Words Remove Duplicate Characters Assuming that you have a list of data in range… read more »

How to Sort Data by Last Character in Excel

This post will guide you how to sort cells by last character in Excel. How do I sort data by the last character with a formula in Excel. How to sort cells based on the last character with User Defined Function in Excel. Sorting Data by Last Character with Formula Sorting Data by Last Character… read more »

How to Vlookup to Return Multiple Values in Excel

This post will guide you how to vlookup to return multiple values in one cell in Excel. How do I lookup and return multiple values concatenated into one cell with an User defined function in Excel. Vlookup to Return Multiple Values in One Cell Assuming that you have a list of data in range A1:B6,… read more »

How to Generate Random Numbers between Two Numbers in Excel

This post will guide you how to generate random numbers between two numbers in Excel. How do I generate random numbers between two numbers without duplicates with VBA macro in Excel. Generate Random Numbers between Two Numbers with Formula Generate Random Numbers between Two Numbers with VBA Generate Random Numbers between Two Numbers with Formula… read more »

How to Remove Numbers from Text in Excel

This post will guide you how to remove all numbers from a text string in one cell in Excel. How do I strip all numeric characters from a given cell with a formula in Excel. How do I remove numbers from cells with text using a User Defined Function in Excel. Remove Numbers From Text… read more »

How to Convert Comments to Cell Contents in Excel

This post will guide you how to convert comments to cell contents in Excel 2010/2013/2016. How do I extract cell contents with VBA Macro in Excel. How do I use a formula to extract comments in a given range in Excel. Convert Comments to Cell Contents with VBA Macro Convert comments to Cell Contents with… read more »

How to Extract URLs from Hyperlinks in Excel

This post will guide you how to extract URLs from hyperlinks using VBA Macro in Excel. How do I extract the actual addresses from hyperlinks in the selected range with a User Defined Function in Excel. Extract URLs from Hyperlinks with VBA Macro Extract URLs from Hyperlinks with User Defined Function Extract URLs from Hyperlinks… read more »

Sidebar