How to use the FIND function

The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function […]

Find a sequence of values – wildcard search

In my last post I showed you how to find a sequence of values. The array formula extracted the row […]

Create name initials

Table of contents Initials from first and last names Initials from first, middle and last names Create middle name initials […]

Formula for matching a date within a date range

Table of contents Match a date when a date range is entered in a single cell Match a date when […]

Exact word in string

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]

Search for a text string in a data set and return matching records

Question: How do I find rows that contain a specific string value in a data set? Answer: Array formula in […]

Split first and last names and sort them alphabetically

Debra Dalgleish at Contextures blog wrote an article Split First and Last Names in Excel. It gave me an idea […]

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