ExcelHow

Author: scott

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

Excel Examples

January 9, 2018
How to count specific words in a cell or a range in Excel

Excel Examples

January 8, 2018
How to convert column letter to number

Excel Examples

January 5, 2018
How to convert column number to letter

Excel Examples

January 3, 2018
How to remove text after a specific character

Excel Examples

December 31, 2017
How to remove text before the first match of a specific character

Excel Examples

December 30, 2017
How to extract text before the second or nth specific character (space or comma)

Excel Examples

December 28, 2017
How to extract word that starting with a specific character

Excel Examples

December 26, 2017
How to join text from two or more cells into one cell separated by commas, space

Excel Examples

December 25, 2017
Check if Cell Contains Certain Values but do not Contain Others Values

Excel Examples

December 24, 2017
How to get last match that cell contains one of several values in a range

Excel Examples

December 24, 2017
How to get first match that cell contains one of several values in a range

Excel Examples

December 23, 2017
How to Extract Text between Commas

Excel Examples

December 23, 2017
How to Extract Text between Parentheses

Excel Examples

December 22, 2017
How to check if Cell contains one of many values from range

Excel Examples

December 21, 2017
How to Check If Cell Contains All Values from Range

Excel Examples

December 21, 2017
How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

Excel Examples

December 20, 2017
Excel EDATE Function

Excel Date/Time functions

December 18, 2017
How to Extract Attribute Values from XML/HTML Data

Excel Examples

December 17, 2017
How to Extract a List of Unique Values from a Column Range

Excel Examples

December 16, 2017