Add Text to Cell Value in Excel

Excel is a robust spreadsheet programme that provides a wealth of functions to aid in the efficient organisation and analysis of your data. The ability to mix text with cell values is one important feature that can be helpful for creating custom labels, adding prefixes or suffixes to existing data, or simply for formatting information.

By the end of this session, you will know how to merge text and cell values in many situations effortlessly using basic formulas, Excel functions, and even more sophisticated methods. Let's get started and learn the methods that will enable you to enrich and manage your data utilising Excel's flexible text concatenation tools!

Plus Text to Cell Value

Here we will first get any one of the values using the formula, then use the autofill handle to complete the task. So let us see a simple process to learn how you can add text to a cell value in Excel.

Step 1

Consider an Excel sheet where you have a list of strings similar to the below image.

First, click on an empty cell, in this case cell C2, and enter the formula as =CONCATENATE("Local ",A2," Grade 3") and click enter to get the first value.

Empty Cell > Formula > Enter.

Step 2

Then drag down using the autofill handle to complete the task.

This is how you can add text to a cell value in Excel.

Note

• To add text at the beginning of a cell value, use the formula =CONCATENATE("text ",A2).

• To add text at the end of a cell, use the formula =CONCATENATE(A2," text")

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can add text to a cell value in Excel to highlight a particular set of data.