How to Add Text to End of Cell in Excel (6 Easy Methods)

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.

How to Add Text to End of Cell in Excel: 6 Methods

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 version 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 Add Text to Multiple Cells in Excel

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.

• 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: How to Add a Word in All Rows in Excel

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

4. Utilizing the CONCATENATE Function to Add Text to the End of a 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.

• 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

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

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

Practice Section

For doing practice by yourself we have provided a Practice section like below on the right side of every worksheet.

Download Practice Workbook

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 in 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.

Related Articles

• How to Add Text in Excel Spreadsheet
• How to Add Text Before a Formula in Excel
• How to Add Text in IF Formula in Excel
• Add Text and Formula in the Same Cell in Excel

<< Go Back to Excel Add Text to Cell Value | Concatenate Excel | Learn Excel