ExcelHow

Tag: Excel VBA Function

How to Remove Non Numeric Characters

Excel Examples, Excel VBA

September 1, 2023
How to Count Only Numbers in Bold in a Range of Cells in Excel

Excel Examples, Excel VBA

July 13, 2023
How to ignore Blank Cells while Concatenating cells in Excel

Excel Examples, Excel VBA

July 12, 2023
How to Sort Data by Last Character in Excel

Excel Examples, Excel VBA

July 3, 2023
How to Sum Only Numbers in Bold in a Range of Cells in Excel

Excel Examples, Excel VBA

June 27, 2023
How to Concatenate Text based on unique values in Another Column in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Extract Email Address from Text

Excel Examples, Excel VBA

April 16, 2023
How to Extract First Letter from Each Word in a Cell in Excel

Excel Examples, Excel VBA

April 8, 2023
Check If a Cell contain Image/Picture

Excel Examples, Excel VBA

April 8, 2023
How to Get the Position of the nth Occurrence of a Character in a Cell

Excel Examples

April 6, 2023
How to Calculate the Average Excluding the Smallest & Highest Numbers in Excel

Excel Examples, Excel VBA

March 11, 2023
How to Get the Maximum or Minimum Absolute Value in Excel

Excel Examples, Excel VBA

February 2, 2020
How to Filter Formula in Excel

Excel Examples, Excel VBA

August 29, 2019
How to Count Cells by Font Color in Excel

Excel Examples, Excel VBA

August 21, 2019
How to Highlight Cells Containing Formulas in Excel

Excel Examples, Excel VBA

August 14, 2019
How to Extract Number from Text String in Excel

Excel Examples, Excel VBA

July 18, 2019
How to Filter Data with Strikethrough Format in Excel

Excel Examples, Excel VBA

July 17, 2019
How to Convert a String into a Formula in Excel

Excel Examples, Excel VBA

March 27, 2019
How to Remove Duplicates in One Cell in Excel

Excel Examples, Excel VBA

March 13, 2019
How to Vlookup to Return Multiple Values in Excel

Excel Examples, Excel VBA

February 26, 2019