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.


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.

Utilizing Flash Fill Feature to Add Text to End of Cell

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.

Utilizing Flash Fill Feature to Add Text to End of Cell

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

Utilizing Flash Fill Feature to Add Text to End of Cell

  • Finally, you will have your output as shown in the screenshot below.

Utilizing Flash Fill Feature to Add Text to End of Cell

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.

Using Ampersand Operator (&)

Steps:

  • First, select cell E5 and insert the following formula.
=D5&" Years"
  • Next, drag the Fill Handle for the remaining cells of the column.

Using Ampersand Operator (&)

  • Eventually, you will have your output as shown in the below screenshot.

Using Ampersand Operator (&)

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.

Using Custom Formatting to Add Text to End of Cell

Steps:

  • First, copy the names into another column where you will add ‘Ph.D’. In this case, we copy it to Column C.

Using Custom Formatting to Add Text to End of Cell

  • Then, select the cells of the new column (Here, we select range C5:C11).
  • After that, right-click on them.
  • Now, select Format Cells.

Using Custom Formatting to Add Text to End of Cell

  • Then, go to Number > Custom.
  • Next, in the space below Type, insert @ “Ph.D”.
  • Consequently, click on OK.

Using Custom Formatting to Add Text to End of Cell

  • Finally, you will finish adding text to the end of the cell as shown in the below screenshot.

Using Custom Formatting to Add Text to End of Cell

Read More: How to Add Text to Beginning of Cell in Excel (7 Quick Tricks)


Similar Readings


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.

Utilizing CONCATENATE Function to Add Text to End of Cell in Excel

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.

Utilizing CONCATENATE Function to Add Text to End of Cell in Excel

  • Finally, you will have your output as shown in the screenshot below.

Utilizing CONCATENATE Function to Add Text to End of Cell in Excel

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.

Using TEXTJOIN Function

Steps:

  • First, select cell E5 and insert the following formula.
=TEXTJOIN(“”,TRUE,D5,” Years”)
  • Next, drag the fill handle to the remaining cells of the column.

Using TEXTJOIN Function

  • Finally, you will have your output as shown in the screenshot below.

Using TEXTJOIN Function

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.

Applying VBA Code to Add Text to End of Cell in Excel

Steps:

  • First, select the cell range D5:D11.

Here, cells D5 and D11 are the first and last cells of the column Age respectively.

Applying VBA Code to Add Text to End of Cell in Excel

  • Now, press ALT+ F11 to open the Visual Basic window.
  • At this point sequentially select, Sheet 6 (VBA Code) > Insert > Module.

Applying VBA Code to Add Text to End of Cell in Excel

  • 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

Applying VBA Code to Add Text to End of Cell in Excel

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.

Applying VBA Code to Add Text to End of Cell in Excel

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.

practice section


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.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo