Exceljet

Quick, clean, and to the point

What is text in Excel

In this video, we're going to take a quick look at the question "what is text in Excel"

Whenever you enter data in an Excel worksheet, Excel checks the data you've entered and classifies it according to 4 basic data types:

Numbers
Dates and times
Boolean values
Text

[animation notes: bring each data type up one at a time. When I say text is the category that excel uses... then "X-out the other types and leave just Text on the screen alone]

Excel figures out the data type based on formatting, and other information it uses to guess your intention.

Text is the category Excel uses when Excel isn't able to classify content as one of the other data types.

To illustrate how Excel classifies data, I'll enter some sample data in column B. Numbers are straightforward. As long as you haven't overridden Excel's default alignment, you'll see numbers are right-aligned automatically.

Text will be left-aligned by default.

Dates and times are right-aligned like numbers. In fact, Excel handles dates and times as numbers. We'll look this in detail in another video.

When a cell contains a formula, Excel classifies the content according to the result of the formula, not the formula itself. So, 2 + 2 returns 4, which is a number.

On the other hand, if we use a formula to concatenate the letter A with the number 1, the result is text. In fact, if we concatenate any number with a another number, we'll get text.

You can also explicitly set content as text by adding a single quote before the value. For example, if we enter '0001, we force Excel to treat this content as text, instead of a number.

Finally, boolean values are a special data type for TRUE and FALSE values. Whether you enter them directly, or they are the result of a formula, excel will display booleans in upper case and center-aligned.

If you ever need to check if a value is text or not, you can use a special function called ISTEXT(). ISTEXT takes a single argument -- the value you are testing -- and returns TRUE or FALSE.

To make these examples easier to read, I can add a conditional formatting rule that highlights TEXT examples. The formula is very simple in this case, because we already have a boolean value in column D. We can just use the formula =$D5 with a dollar sign to anchor the column, and set formatting.

Course 
Core Formula
Author 
Dave Bruns