Excel VBA Function - Free Excel Tutorial - Part 2

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 »

Merge Multiple Cells into One Cell with VBA

This post will guide you how to combine multiple cells into one cell with VBA code in Excel. How do I concatenate a range of cells with VBA macro in Excel 2013/2016. How to merge the contents of two or multiple cells into one cell with macro in Excel. Merge multiple Cells into One Cell… read more »

Randomly Select Cells

This post will guide you how to randomly select cells from a list or table in Excel. How to get random value form a range of cells in an Excel Spreadsheet. Assuming that you have a list of data (B1:B7) in a worksheet, and you want to get 3 random cells or values from those… read more »

Reference Tab Name

This post will guide you how to reference a tab name in one cell in Excel. How do I reference a tab name in cell with a formula in Excel. Can anyone tell me the formula on displaying the name of the current worksheet name in a cell on the Sheet. Reference Tab Name with… read more »

Check If a Cell contain Image/Picture

This post will guide you how to check if a specific cell contains an image or picture in excel. Is it possible to check if a cell contains an image. This post will guide you how to define a User Defined Function to determine if an image exists in a specified cell. Or how to… read more »

Get Cell Value Based on Row and Column Numbers

This post will guide you how to retrieve values using references based on Row and Column numbers in excel. How to get the cell value based on row and column numbers with an excel formula or user defined function in excel. Get Cell Value Based on Row and Column Numbers If you want to retrieve… read more »

How to count and sum cells by background color

This post will guide you how to count and sum cell by background color in excel. How to get the sum of colored cells in the current worksheet. How do I count cells by background color of cells with user defined function in excel VBA. How to Sum cells by background color in excel. Count… read more »

How to extract nth word from text string

This post will guide you how to extract the nth word from a text string in excel. How do I get the nth word from text string in a cell using excel formula. How to write a User Defined Function to extract nth word from text. Extract nth word If you want to extract the… read more »

How to count the number of words in a cell in Excel

This post explains that how to count the number of words in a cell using excel formula. How to count total words in a cell with User Defined Functions in excel VBA. Count the number of words in a cell If you want to count the number of words in a single cell, you can… read more »

How to convert column letter to number

This post will guide you how to convert a column letter to a column number using an excel formula. And how to write a user defined function to convert column letter to number in excel VBA. Convert column letter to number using excel Formula If you want to convert a column letter to number, you… read more »

Sidebar