ExcelHow

Tag: Excel Function

How to Count Spaces before the Text String

Excel Examples, Excel VBA

April 18, 2023
How to Transpose Values Based on the Multiple Lookup Criteria

Excel Examples

April 17, 2023
How to extract text after the second or nth specific character (space or comma)

Excel Examples, Excel VBA

April 8, 2023
How to Count Numbers with Leading Zeros

Excel Functions, Excel VBA

April 8, 2023
How to remove non numeric characters from a cell

Excel Examples

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

Excel Examples

April 6, 2023
How to extract text after first comma or space

Excel Examples, Excel VBA

April 3, 2023
How to get first word from text string

Excel Examples, Excel VBA

April 3, 2023
How to Lookup the Next Largest Value

Excel Examples, Excel VBA

March 29, 2023
How to get nth Match with One Criteria using INDEX/MATCH

Excel Examples

March 27, 2023
Sort by Second or Third character in a Column

Excel Basics, Excel Examples

February 25, 2023
How to count the number of line breaks in a cell

Excel Examples

February 19, 2023
How to Generate Random Passwords in Excel

Excel Basics, Excel Examples

February 19, 2023
Excel DVARP Function

Excel Database Functions

May 13, 2018
Excel DVAR Function

Excel Database Functions

May 13, 2018
Excel DSUM Function

Excel Database Functions

May 13, 2018
Excel DSTDEVP Function

Excel Database Functions

May 12, 2018
Excel DSTDEV Function

Excel Database Functions

May 12, 2018
Excel DMIN Function

Excel Database Functions

May 11, 2018
Excel DPRODUCT Function

Excel Database Functions

May 11, 2018