Excel VBA Function

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 »

Reverse Text String in Excel

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »

Insert Created Date and Last Modified Date in Cells

This post will guide you how to insert the created date and last modified date of the current workbook in a cell in Excel. How do I insert the date an excel workbook was last modified in a cell. How to insert last modified date in Excel. Insert Created Date and Last Modified Date in… read more »

Removing Non Numeric Characters

This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… read more »

Excel Sum Numbers Ignore Text

This post will guide you how to sum numbers ignore text in same cell in Excel. How do I sum numbers with text appended in the same cell with a formula in excel.How to sum only numbers in a cells with text and numbers using User Defined Function in Excel. Sum Numbers Ignore Text To… read more »

Sidebar