Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Plus 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.
477 Views
