How to Add Text After a Formula in Google Sheets
It is absolutely possible to add text after the formula for the users in Google sheets.
Adding text after a formula is generally required in the case of currencies like USD, Rupees, etc, and in the case of measurements like kg, g, ml, mg, etc too. You can also add multiplication formulas in Google sheets and not the multiplication formula but addition, subtraction, division, and all other formulas too. In this article, our main focus would be to master the technique to add text after formula in just 4 easy steps.
How to combine text values using CONCATENATE & TRANSPOSE functions
Add Text After a Formula in Google Sheets in 4 Steps
Step-1 Open Up Your Google Sheet: The very basic step which is also the first step of this process is to go to your Google sheet in which you want to add the text after a formula.
So, to open an existing Google sheet, do the following:
- Open Chrome web browser (you can also open any other web browser).
- Paste the link of your Google sheet.
- Hit the 'Enter' button on your keyboard.
- Your sheet will open up.
Step-2 Select The Cell: Now, you will be able to see your Google sheet on the screen in front of you.
In this step, you have to select the cell in which you want to add text after the formula. To select a particular cell, click on it. It will be selected.
Step-3 Type Your Formula And Text: Then, it is time to proceed to the main task. Do it in two steps:
- First, you have to enter the formula with the help of the mathematical operation that you want to perform.
- After that, put a comma (,).
- Then, you have to open the double inverted commas (" ").
- In between the double inverted commas, add the text that you want to be displayed.
For instance, your cell should look something like ( =b2*c2&",Your text" ).
Step-4 Text is Added After Formula: Now, when you press the Enter button, you will see that your mathematical operation has taken place. And, your text is also added after the formula.
FAQ
What Is The 'Concatenate' function in Google Sheets?
We use the CONCAT formula in Google sheets to join two or more strings of text together into one string. It helps to add formulas and functions.
There are several other alternatives if you do not want to use the CONCAT function. Some of them are:=CONCATENATE() - This function is used to join two or more strings of text together. It can also include cells, ranges, and text values.
How Can I Combine Text and Formulas in Sheets?
There are several ways in which you can Combine Text and Formulas in Sheets. Here, we are going to explain the easiest and the fastest way to do so.
We will perform the concatenation technique. In simple words, concatenate means 'to join'. Let's see what is that:
- Firstly, select a cell and then press '=' (the equal sign).
- Now, you have to click the first cell that you want to refer to in the join.
- Then, press the '+' sign (the plus sign).
- After that, click on the second cell that you want to refer to (to join the values together).
- Finally, press 'Enter' to concatenate.
Can I Insert a Letter After a Formula in Microsoft Excel?
You can absolutely do that but the process is very different from what we were doing in Google sheets.
So, read the given steps carefully to know how to insert letter after formula in Excel:
- Select your preferred cell.
- Go to the 'Ablebits' tab.
- Then, go to the 'Text' group.
- In the Text groups, you have to find and click on the 'Add' option.
- Now, move to the 'Add Text' pane.
- Then, you have to type the character or text that you wish to add to the selected cells. Also, specify the position of the text.
- Finally, click on the 'Add Text' button.
- Then, hit 'Done'.