There might come some instances, where you need to add text to the end of a cell or cells in excel. Microsoft Excel enables you to do such tasks in bulk and within seconds. This article demonstrates how to add text to the end of a cell in Excel with 6 easy methods.
Download Practice Workbook
You can download the practice workbook from the link below.
6 Methods to Add Text to End of Cell in Excel
In many cases, you might need to add text to the end of the cell in Excel. You can add text to the end of a cell very easily in Excel. Now, I will show you 6 easy methods to do so.
We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.
1. Utilizing Flash Fill Feature to Add Text to End of Cell
Let’s assume we have a dataset where we have a list of employees and their respective ages. Now, we want to add “Years” to the end of each of the cells in column Age. We can easily do this using the Flash Fill feature in Excel. At this point, follow the below steps to do so.
Steps:
- First, write the age in the first cell of the column Age into a new cell to the right of it and add Years. In this case, we write 34 Years in cell E5.
Here, E5 is the first cell of the new column Add Text.
- Then, select cell E6 and press CTRL + E if you are a Windows user or COMMAND + E if you are a MAC user.
Here, cell E6 is the second cell of the column Add Text.
- Finally, you will have your output as shown in the screenshot below.
Read More: How to Combine Text and Number in Excel (4 Suitable Ways)
2. Using Ampersand (&) Operator
Another method to add text to the end of a cell is to use the Ampersand operator. Now, follow the steps below to do so.
Steps:
- First, select cell E5 and insert the following formula.
=D5&" Years"- Next, drag the Fill Handle for the remaining cells of the column.
- Eventually, you will have your output as shown in the below screenshot.
Read More: Combine Text and Formula in Excel (4 Simple Ways)
3. Using Custom Formatting to Add Text to End of Cell
Now, suppose you want to add text at the end of another text in a cell. In this case, you want to add ‘Ph.D’ at the end of every Professor Name. You can do this by using custom formatting. At this point, to do so follow the below steps.
Steps:
- First, copy the names into another column where you will add ‘Ph.D’. In this case, we copy it to Column C.
- Then, select the cells of the new column (Here, we select range C5:C11).
- After that, right-click on them.
- Now, select Format Cells.
- Then, go to Number > Custom.
- Next, in the space below Type, insert @ “Ph.D”.
- Consequently, click on OK.
- Finally, you will finish adding text to the end of the cell as shown in the below screenshot.
Read More: How to Add Text to Beginning of Cell in Excel (7 Quick Tricks)
Similar Readings
- How to Add Text in Excel Spreadsheet (6 Easy Ways)
- Add a Word in All Rows in Excel (4 Smart Methods)
- How to Add Text Labels in Excel Chart (4 Quick Methods)
4. Utilizing CONCATENATE Function to Add Text to End of Cell in Excel
One other method to add text to the end of a cell is to use the CONCATENATE function. Now, to do so follow the steps below.
Steps:
- At the very beginning, select cell E5 and insert the following formula.
=CONCATENATE(D5," Years")- Next, drag the fill handle to the remaining cells of the column.
- Finally, you will have your output as shown in the screenshot below.
Read More: How to Add Text to Cell Without Deleting in Excel (8 Easy Methods)
5. Using TEXTJOIN Function
Also, you can use the TEXTJOIN function in Excel to add text to the end of a cell in Excel. Now, follow the below steps to do so.
Steps:
- First, select cell E5 and insert the following formula.
- Next, drag the fill handle to the remaining cells of the column.
- Finally, you will have your output as shown in the screenshot below.
Read More: How to Add Text in the Middle of a Cell in Excel (5 Easy Methods)
6. Applying VBA Code to Add Text to End of Cell in Excel
In this method, we will apply VBA code to add text to the end of a cell. Now, to do so follow the below steps.
Steps:
- First, select the cell range D5:D11.
Here, cells D5 and D11 are the first and last cells of the column Age respectively.
- Now, press ALT+ F11 to open the Visual Basic window.
- At this point sequentially select, Sheet 6 (VBA Code) > Insert > Module.
- Then, copy the following code and paste it into the blank space.
'This Code Will Add Text to End of Selected Cells
Sub textatend()
'Declaring Variables
Dim cr As Range
Dim dat As Range
'Assigning Selected Cells To a Variable
Set cr = Application.Selection
'Running Loop to Add Text
For Each dat In cr
dat.Offset(0, 1).Value = dat.Value & " Years"
Next dat
End Sub
In this code, we assign a value to the variable cr by setting the selected range to it. Also, we use the For loop, which will add the text ‘Years’ to each cell of column Age and insert the result in the next column.
- Next, press F5 to run the code.
- Finally, you will have your output as shown in the below screenshot.
Read More: How to Add Text to Cell Value in Excel (4 Easy Ways)
Practice Section
For doing practice by yourself we have provided a Practice section like below on the right side of every worksheet.
Conclusion
In this article, we see how to add text to the end of a cell in Excel with the help of 6 easy methods. Last but not least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.
