## 'TRIM function' category

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also multiple blanks between words. The […]

The picture above shows you values that have multiple leading and trailing blanks, sometimes also multiple blanks between words. The […]

Extract specific word based on position in cell value

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

How to use the COUNTIF function to count not blank cells

The COUNTIF function is very capable of counting non-empty values, I will show you how in this article. Excel can […]

The COUNTIF function is very capable of counting non-empty values, I will show you how in this article. Excel can […]

Count identical values if they are on the same row

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

Working with classic ciphers in Excel

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

A Comprehensive Guide to Splitting Text in Excel

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

How to extract email addresses from an Excel sheet

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values