How to Add Text to Cell Without Deleting in Excel (8 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

When we input a large amount of data into our dataset, we unconsciously miss some text of that data. Moreover, sometimes we need to add a specific text to all the entities of our dataset. Excel has several options to do such tasks in a short period. In this article, we will demonstrate 8 easy methods to add text to the cell without deleting it in Excel. If you are curious about it, download our practice workbook and follow us.


How to Add Text to Cell Without Deleting in Excel: 8 Quick Ways

To demonstrate the approaches, we consider a dataset of 10 male employees of an institution. Their name is in the range of cells B5:B14. The text we are going to add with their name is in cell E5. After addition, the result will be in column C.


1. Applying CONCATENATE Function

In this method, we will use the CONCATENATE function to add text to our existing text. The steps of this method are given below:

📌 Steps:

  • First of all, select cell C5.
  • Now, write down the following formula in the cell. Make sure that you input the Absolute Cell Reference for cell E5.

=CONCATENATE($E$5,B5)

  • Press Enter.

Applying CONCATENATE Function to Add Text to Cell Without Deleting

  • Then, double-click on the Fill Handle icon to copy the formula up to cell C14.

  • You will get your desired text added to the existing text.

Applying CONCATENATE Function to Add Text to Cell Without Deleting

Thus, we can say that our formula worked perfectly, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In this demonstration, we add the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to alter the cell reference inside the formula. In such case, the formula will be:

=CONCATENATE(B5,$E$5)

Read More: How to Add Text in Excel Spreadsheet


2. Using CONCAT Function

In this process, we are going to use the CONCAT function to add text to our existing text. The steps of this approach are given as follows:

📌 Steps:

  • First, select cell C5.
  • After that, write down the following formula in the cell. Ensure that you input the Absolute Cell Reference for cell E5.

=CONCAT($E$5,B5)

  • Press Enter.

Using CONCAT Function to Add Text to Cell Without Deleting

  • Now, double-click on the Fill Handle icon to copy the formula up to cell C14.

  • You will get your desired text added to the existing text.

Using CONCAT Function to Add Text to Cell Without Deleting

So, we can say that our formula worked precisely, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In this example, we added the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to alter the cell reference inside the formula. In that case, the formula will be:

=CONCAT(B5,$E$5)

Read More: How to Add Text to Beginning of Cell in Excel


3. Utilizing TEXTJOIN Function

In this approach, the TEXTJOIN function will help us to add text to our existing text. The procedure of this approach is given below:

📌 Steps:

  • At first, select cell C5.
  • Afterward, write down the following formula in the cell. Make sure that you input the Absolute Cell Reference for cell E5.

=TEXTJOIN("",TRUE,$E$5,B5)

  • Press Enter.

Utilizing TEXTJOIN Function to Add Text to Cell Without Deleting

  • Next, double-click on the Fill Handle icon to copy the formula up to cell C14.

  • You will get your desired text added to the existing text.

Utilizing TEXTJOIN Function to Add Text to Cell Without Deleting

Hence, we can say that our formula worked effectively, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In following the demonstration, we added the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to alter the cell reference inside the formula. In such case, the formula will be:

=TEXTJOIN(“”,TRUE,B5,$E$5)

Read More: How to Add Text to End of Cell in Excel


4. Using Ampersand Operator

In this case, we are going to use the Ampersand operator to add text to our existing text. The steps of this method are given below:

📌 Steps:

  • In the beginning, select cell C5.
  • Now, write down the following formula in the cell. Input the Absolute Cell Reference for cell E5.

=$E$5&B5

  • Press Enter.

Using Ampersand Operator to Add Text to Cell Without Deleting

  • After that, double-click on the Fill Handle icon to copy the formula up to cell C14.

  • You will get your desired text added to the existing text.

Using Ampersand Operator to Add Text to Cell Without Deleting

At last, we can say that our formula worked successfully, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In the following example, we add the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to alter the cell reference inside the formula. In such case, the formula will be:

=B5&$E$5

Read More: How to Add a Word in All Rows in Excel


5. Modifying Cell Format

In the following method, we will change the cell format to add text to our existing text. In this case, Excel will automatically add that text to every entity of our selected cell range. The text that we will add to our existing text is in cell D5. The steps of this process are explained below:

📌 Steps:

  • At the beginning of this process, select the range of cells B5:B14.
  • Now, in the Home tab, click on the Format Cell dialog box launcher.

Modifying Cell Format to Add Text to Cell Without Deleting

  • As a result, the Format Cell dialog box will appear in front of you.
  • Then, in the Number tab, click on the Custom option.
  • After that, write down the following text in the box below the Type. We will also get a preview of your cell format.

"Mr. "@

  • Finally, click OK.

Modifying Cell Format to Add Text to Cell Without Deleting

  • You will notice that all the selected cells get the text in front of the existing text.

Modifying Cell Format to Add Text to Cell Without Deleting

  • Now, if you click on cell B5, you will see in the Formula Bar the cell contains the previous text, Harry. However, due to our custom cell formatting, it is showing Mr. Harry.

Finally, we can say that our method worked perfectly, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In this example, we add the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to alter the text position. In such case, the custom cell format will be:

@ “Text”

Read More: How to Add Text to Multiple Cells in Excel


6. Using Flash Fill Command

The Excel Flash Fill command is another option to add text to our existing text in a cell. The text that we will add to our existing text is in cell D5. The approach is explained below step-by-step:

📌 Steps:

  • First of all, select cell B5 and press ‘Ctrl+C’ to copy.

  • After that, press ‘Ctrl+V’ to paste the data into cell C5.

  • Now, in the Formula Bar, click before the text using your mouse.
  • Then, write down the following text with our existing text.

Mr.

  • Press Enter.

Using Flash Fill Command to Add Text to Cell Without Deleting

  • Afterward, double-click on the Fill Handle icon to copy the text up to cell C14.
  • You may notice the same data copied in all the cells.

Using Flash Fill Command to Add Text to Cell Without Deleting

  • Now, click on the Auto Fill Options icon and choose the Flash Fill option.
  • You will see within a second all the data of column C get the corresponding value of column B.

Using Flash Fill Command to Add Text to Cell Without Deleting

In the end, we can say that our method worked effectively, and we were able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In this demonstration, we add the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to input the text after your existing text.


7. Using Keyboard Shortcut

In the following process, we will use the keyboard shortcut to add text to our existing test. It is a manual process. The text that we are going to add to our text is in cell D5. The procedure is given below:

📌 Steps:

  • First, select cell B5.
  • Now, press the ‘F2’ or ‘Fn+F2’ key.
  • You will notice the cell will go into editing mode.

Using Keyboard Shortcut to Add Text to Cell Without Deleting

  • Then, place the mouse cursor in front of the existing text and write down the following text.

Mr.

  • Press Enter.

  • Similarly, follow the same procedure to add the text to all the entities.
  • You will get all the text with the newly added text.

Using Keyboard Shortcut to Add Text to Cell Without Deleting

Thus, we can say that our method worked precisely, and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In this example, we add the text in front of our existing text. If you want to add the text at the end, the procedure will be the same. However, you have to input the text after your existing text. As this is a manual process, if you have to add any text to a large number of entities, we recommend you not follow this method. It will kill your valuable time.

Read More: How to Add Text in the Middle of a Cell in Excel


8. Embedding VBA Code

Writing a VBA code can also help you to add text to the cell without deleting it. To show this method, we are using the same datasheet which we have already used. Our dataset is in the range of cells B4:B14. The steps of this process are given as follows:

📌 Steps:

  • To start the approach, go to the Developer tab and click on Visual Basic. If you don’t have that, you have to enable the Developer tab. You can also press ‘Alt+F11’ to open the Visual Basic Editor.

Embedding VBA Code to Add Text to Cell Without Deleting

  • A dialog box will appear.
  • Now, in the Insert tab on that box, click the Module option.

  • Then, write down the following visual code in that empty editor box.

Sub Add_Text()
Dim A As Range
For Each A In Selection
If A.Value <> "" Then A.Value = "Mr. " & A.Value
Next
End Sub
  • Close the Editor tab.
  • Now, select the range of cells B5:B14.

  • After that, in the Developer tab, click on Macros.

Embedding VBA Code to Add Text to Cell Without Deleting

  • A new dialog box called Macro will appear.
  • Select Add_Text and click on the Run button to run this code.

Embedding VBA Code to Add Text to Cell Without Deleting

  • Finally, you will see the new text is added to our existing text.

Embedding VBA Code to Add Text to Cell Without Deleting

Finally, we can say that our visual code worked successfully and we are able to add text to the cell without deleting it in Excel.

💬 Things You Should Know

In the following example, we add the text in front of our existing text using the VBA code. If you want to add the text at the end, you have to modify the code. The rest of the procedure is the same. We are showing a modified code for your convenience.

Sub Add_Text()
Dim A As Range
For Each A In Selection
If A.Value <> "" Then A.Value = A.Value & " Text"
Next
End Sub

Read More: How to Add Text to Cell Value in Excel


Download Practice Workbook


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to add text to the cell without deleting it in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo