How to Begin a Cell with an =, -, or + Sign Without Creating a Formula
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...
top of page
Recent Posts
How to Remove Extra Spaces from Text
Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....
How to Reverse or Flip First and Last Names in Excel
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....
How to Wrap Text in Excel and When to Use it
The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...
How to Convert a Month Name to a Number in Excel
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...
How to Return the ASCII Number for Every Character in a Cell
The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....
How to Use the CODE Function
The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...
How to use the CLEAN Function
The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...
How to Abbreviate a Middle Name in a Full Name in Excel
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...
How to Separate a Full Name Into First and Last Names in Excel
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...
How to Combine First & Last Names Into a Full Name in Excel
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....
How to Extract Everything to The Left of a Specific Character in Excel
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...
How to Extract Everything to The Right of a Specific Character in Excel
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...
How to use the BAHTTEXT Function in Excel with Examples
The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...
How to use the DOLLAR Function in Excel with Examples
The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...
How to Get a Sheet Name Using a Formula in Excel - 3 Methods
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...
How to use the PROPER Function in Excel - 3 Examples
The PROPER function will convert any string of words into "proper" capitalization. The first character/letter of every word will...
How to use the LOWER Function in Excel - 2 Examples
What is the LOWER function and how to use it, with multiple practical examples.
How to use the UPPER Function in Excel - 2 Examples
What is the upper function and how do you use it? The UPPER function explained.
bottom of page