Google Sheets Text: What Cells Can Store and Do

Yes. Google Sheets can store text in cells, including words, numbers treated as text, symbols, and combinations such as product codes or email addresses. You can type text directly, import it, or create it with a formula, then format, search, sort, and manipulate it.

What text means in Google Sheets

A spreadsheet cell can hold different kinds of values. Text is a sequence of characters that Sheets treats as a text value rather than as a number or date. Examples include a person’s name, a street address, a note, or the code AB-0042. A cell can also contain a formula; the formula may return text as its result.

This distinction matters because Sheets handles values according to their type. A number can be added or used in arithmetic, while a text string is generally handled as characters. A cell containing the text 42 may look just like a cell containing the number 42, but the first is not automatically interchangeable with the second in calculations. Dates and times also have numeric values behind their display, so what looks like a date is not necessarily stored as plain text.

Text is not limited to letters. Spaces, punctuation, currency symbols, and digits can all be part of a text value. For instance, a phone number such as 020 7946 0958 is often best stored as text because its spaces and leading zero are identifying characters, not quantities to calculate.

How to enter text in a cell

To add a text value, open a spreadsheet in a browser, select a cell, type the text, and press Enter. You can also double-click a cell to edit its contents, or select it and type in the formula bar above the grid. Pressing Enter normally commits the entry and moves the selection to another cell; pressing Tab commits it and moves to the next column.

Type labels such as Department or Status directly into cells.
Paste text from another document or webpage. Check the result if the source includes tabs or line breaks, since those may place content into multiple cells.
Use an apostrophe before an entry when you need Sheets to interpret an input as text. The apostrophe acts as an entry prefix rather than appearing as part of the displayed value.
For a column of codes or identifiers, set the cells to plain text before entering or importing values if leading zeros must remain intact.

For example, typing 00721 into a cell formatted as a number can cause the leading zeros to disappear. If the code is an identifier, not a quantity, format the destination as plain text first using Format > Number > Plain text. Then enter or paste the code. Changing a cell’s format after Sheets has already converted the entry may not restore characters that were discarded, so it is safer to set the format in advance.

Text, numbers, and what a cell displays

The value stored in a cell and the way the cell looks are related but not identical. Number formatting can change how a numeric value is displayed without turning it into text. For example, a numeric value may be displayed with a currency symbol or a chosen number of decimal places. A custom number format can also show leading zeros while retaining a numeric value, but that does not make the underlying value a text identifier.

Plain text formatting tells Sheets to treat entries as text, which is useful for codes, postal codes, and values that begin with characters that would otherwise be interpreted specially. It does not add quotation marks around the content. By contrast, wrapping and alignment affect presentation, not the value type. To wrap long text across multiple lines within a cell, select the cells and choose Format > Wrapping > Wrap. The full content remains in the cell even if it is not all visible at once.

Formulas can return text too. A formula’s result may look like ordinary text in the grid, but the cell still contains a formula, which you can see in the formula bar when selecting it. This is useful for creating labels from other cells, joining names, or producing readable messages from spreadsheet data.

Using formulas to check or clean text

Google Sheets includes functions for checking text values and working with their characters. The following examples use ordinary cell references and are also valid Excel formulas. In each case, the formula goes in a different cell from the source value so it does not overwrite it.

With the text North in A1, enter =ISTEXT(A1) in B1. It returns TRUE because A1 contains text.
With North in A1, enter =LEN(A1) in B1. It returns 5, the number of characters in the value.
With the text containing extra spaces, such as two spaces before red and several between red and apple, in A1, enter =TRIM(A1) in B1. It returns red apple with excess spaces between words removed and leading and trailing spaces removed.
With the text 42 in A1, enter =VALUE(A1) in B1. It returns the numeric value 42, provided the text can be interpreted as a number.

Other useful text functions include LEFT, RIGHT, and MID for extracting characters; SPLIT for dividing text around a separator; and TEXTJOIN for combining values with a chosen delimiter. For example, SPLIT can separate a comma-delimited entry into pieces, while LEFT can take the first few characters of a code. When cleaning imported data, TRIM can remove many unwanted spaces, though unusual nonbreaking spaces copied from websites may need extra attention.

Formatting and organizing text

Text formatting controls appearance rather than meaning. In the Sheets browser interface, you can change font, size, color, and text style using the toolbar, or use Format for related options. You can also change horizontal alignment, wrap long entries, and adjust row height or column width. These choices make labels and notes easier to read but do not convert text into a number.

For larger tables, keep one kind of information in each column when practical. Put a customer’s first name in one column and last name in another, for example, rather than combining both with unrelated notes in one cell. Consistent structure makes it easier to sort, filter, count, and reuse the data. If you need a combined display name, create it in a separate column so the original components remain available.

Sheets can sort and filter text in a range. Select the data and use Data > Sort range or create a filter with Data > Create a filter. Include the relevant headers and associated rows when sorting a table; sorting only one column can separate names from their corresponding records. Filters can help show rows that contain a particular value, but they do not change or delete the underlying cell content.

Common text problems and how to fix them

Several everyday spreadsheet surprises come from a mismatch between the value a person intended to enter and the type Sheets inferred. Look at the cell’s contents in the formula bar and consider its format before changing data. These checks can prevent accidental edits to valid values.

Leading zeros disappeared: The entry may have been interpreted as a number. Set the cells to Format > Number > Plain text before entering the values again, or restore the original codes from a reliable source.
A date or number was interpreted unexpectedly: Sheets may recognize an entry as a date or numeric value based on its form and spreadsheet locale. Set the intended format before entering data, and verify ambiguous dates such as 03/04/2026 rather than assuming which month comes first.
Search or matching does not find an apparent match: One value may contain extra spaces, different punctuation, or an invisible character. Compare the cell contents, try TRIM for ordinary excess spaces, and inspect a sample of the source data before applying cleanup to an entire column.
Text appears cut off: The column may be too narrow, or adjacent cells may contain values that prevent overflow from being visible. Widen the column or choose Format > Wrapping > Wrap.
A pasted list spreads across cells: Tabs and line breaks in copied content can act as separators. Undo if needed, then paste into the intended area or clean the source before pasting.

For imported files, check the import preview and any available separator or conversion options instead of assuming that every column will retain its original interpretation. A CSV file stores delimited text, not the complete spreadsheet formatting and formula behavior of a native Sheets file. After importing, inspect columns containing dates, long numbers, leading zeros, or codes, since automatic interpretation can affect how values appear or are stored.

Google Sheets compared with Excel

Both Google Sheets and Microsoft Excel can store text in cells, distinguish text from numbers, and offer functions for extracting or combining characters. The basic idea is the same: a cell’s displayed appearance does not always reveal its underlying value type. Many familiar functions, including ISTEXT, LEN, and TRIM, are available in both programs, though the exact function set and details can differ.

The instructions here use Google Sheets in a web browser. Its menus include paths such as Format > Number > Plain text and Data > Create a filter. Excel for Microsoft 365 uses its own ribbon and menu layout, so those exact Sheets paths should not be followed in Excel. Also, a file opened in both programs may not preserve every feature or formatting choice identically; check important data after converting or exporting a workbook.

Frequently Asked Questions

Can Google Sheets store text and numbers in the same column?
Yes. A column can contain both, but mixed types can make sorting, filtering, and calculations less predictable. If the entries represent the same kind of information, use a consistent format where possible.

How do I make Google Sheets keep leading zeros?
Before typing or importing the values, select the destination cells and choose Format > Number > Plain text. This is especially helpful for account codes, postal codes, and identifiers that are not used in arithmetic.

Can a Google Sheets formula return text?
Yes. Formulas can produce text directly or combine values from other cells. The cell displays the result, while selecting it lets you view the formula in the formula bar.

Why does text look like a number in Google Sheets?
A string of digits can look identical to a numeric value in the grid. Check how it behaves in calculations and inspect the cell’s format or use ISTEXT in a separate cell to check whether it is text.

Does formatting a cell as plain text change existing content?
It may affect how later entries are interpreted, but it does not reliably recover characters already lost through conversion, such as removed leading zeros. Re-enter or re-import the original value after setting the format if necessary.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.