Excel VBA Function

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 »

How to Sum Only Filtered Data or Visible Cell Values in Excel

This post will guide you how to sum only visible cell values in Excel. How do I sum only visible cell values in a selected range with a formula in Excel. How to sum only visible rows when filtering data in your worksheet with VBA code in Excel. Sum Filtered Data Only with Formula Sum… read more »

How to Count And Sum Cells by Color in Excel

This post will guide you how to count and sum cells by font color or cell color in Excel. How do I sum cell values by font color with VBA code in Excel. How to sum cells by color with formula in Excel. Sum Cells by Cell Color with Filter feature Sum Cells by Cell… read more »

How to convert Column Letter to Number in Excel

This post will guide you how to convert column letter to number in Excel. How do I convert letter to number with a formula in Excel. How to convert column letter to number with VBA macro in Excel. How to use a User Defined Function to convert letter to number in Excel. Convert Column Letter… read more »

Extract Email Address from Text

This post will guide you how to extract email address from a text string in Excel. How do I use a formula to extract email address in Excel. How to extract email address from text string with VBA Macro in Excel. Assuming that you have a list of data in range B1:B5 which contain text… read more »

Get and Insert the Last Modified User Name

This post will guide you how to get and insert the last modified user name of your current workbook in Excel 2007/2013/2016. How do I see who is the last modified user in Excel 2013/2016. How to insert the last modified username in Excel. How to insert the last modified username into a cell with… read more »

Convert Numbers into Words in Excel

This post will guide you how to convert numbers into words in Excel. How do I convert a numeric word into English words with VBA Function code in Excel. How to convert Numbers (Currency) to words with Excel VBA User Defined Function. Convert Numbers into Words The Excel doesn’t have a default function that displays… read more »

Sidebar