Recent Posts

Sometimes you find yourself wanting to start a cell with an "=", "-", or a "+" sign, but don't want Excel to create a formula. There are...

Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....

You'll often see names that are out of order, and need to flip them. Here are a couple quick formulas to help you accomplish that task....

The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...

Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...

The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....

The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...

The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...

Formatting names can be a manual and slow process. Here is a quick method to turn a middle name into a middle initial when given a full...

Often, you'll receive a list of first and last names combined into a full name and need to separate them. Here's a quick method to easily...

Often, you'll receive a list of names broken up into two separate columns, first and last, and need to combine them into a full name....

A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to pull out...

A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...

The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...

The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...

When working in a workbook with a lot of different tabs, being able to pull, reference, and use specific sheet names can save you a lot...

The PROPER function will convert any string of words into "proper" capitalization. The first character/letter of every word will...

What is the LOWER function and how to use it, with multiple practical examples.

What is the upper function and how do you use it? The UPPER function explained.