How to use the UPPER function

Converts a value to upper case letters. Formula in cell C3: =UPPER(B3) Table of Contents UPPER Function Syntax UPPER Function Arguments UPPER Function […]

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 […]

Count multiple text strings in a cell range

This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range.  The […]

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]