'TRIM function' category
Extract values between two given delimiting strings
The image above demonstrates a rather small formula in cell D3 that extracts values in cell B3 based on two […]
The image above demonstrates a rather small formula in cell D3 that extracts values in cell B3 based on two […]
How to count blank cells
The image above shows the COUNTBLANK function counting empty cells in cell range B3:B14. Note that the COUNTBLANK function ignores […]
The image above shows the COUNTBLANK function counting empty cells in cell range B3:B14. Note that the COUNTBLANK function ignores […]
Extract n-th word in cell value
The formula displayed above in cell range D3:D9 extracts a word based on its position in a cell value. For […]
The formula displayed above in cell range D3:D9 extracts a word based on its position in a cell value. For […]
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 last word in cell
Table of Contents Extract the last word Extract the last letter Extract the last number Get Excel *.xlsx file 1. […]
Table of Contents Extract the last word Extract the last letter Extract the last number Get Excel *.xlsx file 1. […]
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 […]
How to create name initials
The array formula in cell C3 extracts the first character from first, middle and last name. The formula works fine […]
The array formula in cell C3 extracts the first character from first, middle and last name. The formula works fine […]
Text to columns: Split words in a cell
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