Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to add text to formulas in Google Sheets.
How To Add Text To Formula in Google Sheets
Google Sheets makes it easy for users to add formulas to their spreadsheet. But sometimes, you may want to add additional text to these formulas.
For example, let’s say you have a formula that adds up the values in a certain column. You may want to add a description of what the formula is calculating, right before the formula itself.
Instead of our target cell holding just the sum of values, it might say “The sum of all values in Column A is <sum>”.
In this guide, we will show you how to add your own custom text to a formula in Google Sheets. We will cover how to use the append character “&” to combine text strings with formula results.
How to Add Text to a Formula in Google Sheets
Here’s our step-by-step guide on how to add text to a formula in Google Sheets.
First, select the cell where you want to add your new formula.
In our example, we want to generate a meaningful output that the user can quickly read. For example, instead of having just the value “7175”, we want our cell to say “We have a total of 7175 orders.”
We can achieve that output by appending text and formulas using the “&” character. We’ll need to add a string with all the text we want to appear before the formula and another string with all the text after the formula’s result.
In this example, we have a SUM function surrounded by two strings. All three of these values are appended into a single text output using the “&” character.
In our second example, we’ll create a formula that shows the current date in a specific readable format.
We’ll start by adding the phrase “Today is “.
We’ll use the formula TEXT(TODAY(),”ddd, mmm dd yyyy”) to format the current date into a specific format
The “&” symbol will combine both strings into a single text output.
This guide should be everything you need to learn to start adding text to a formula in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize