ExcelHow

Category: Excel Examples

How to Fill Blank Cells with Value above

Excel Basics, Excel Examples

January 30, 2018
Change background color of cells based on value

Excel Basics, Excel Examples

January 28, 2018
How to insert leading zeros to number or text

Excel Examples

January 26, 2018
Split full name to first and last name

Excel Examples

January 24, 2018
How to add text to the end all cells

Excel Basics, Excel Examples

January 22, 2018
How to add text to the beginning of all cells

Excel Basics, Excel Examples

January 21, 2018
How to combine columns without losing data

Excel Basics, Excel Examples

January 20, 2018
How to combine multiple workbooks into one workbook

Excel Basics, Excel Examples

January 19, 2018
How to remove unwanted characters from text string

Excel Examples

January 16, 2018
How to extract nth word from text string

Excel Examples

January 14, 2018
How to count the number of words in a range of cells in Excel

Excel Examples

January 10, 2018
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