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

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.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


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

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 into 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: Combine Text and Formula in Excel (4 Simple Ways)


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 into 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 (7 Quick Tricks)


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 into 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 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:

=TEXTJOIN(β€œβ€,TRUE,B5,$E$5)

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


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 into 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


Similar Readings


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 with 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 (10 Easy Methods)


6. Using Flash Fill Command

Excel Flash Fill command is another option to add text to our existing text in a cell. The text that we will add with 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 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 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 with 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 to follow this method. It will kill your valuable time.

Read More: How to Add Text in the Middle of a Cell in Excel (5 Easy Methods)


8. Embedding VBA Code

Writing a VBA code can also help you to add text to the cell without deleting it. For showing 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. Or You can also press β€˜Alt+F11’ for opening 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 (4 Easy Ways)


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

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo